Data Types

openGauss supports implicit conversions between certain data types. For details, seePG_CAST .

• Numeric Types

• Monetary Types

• Boolean Types

• Character Types

• Binary Types

• Date/Time Types

• Geometric

• Network Address Types

• Bit String Types

• Text Search Types

• UUID

• JSON/JSONB Types

• HLL

• Range

• OID Types

• Pseudo-Types

• Data Types Supported by Column-store Tables

• XML Types

• Data Type Used by the Ledger Database