Data Types

A data type is a basic data attribute. Occupied storage space and allowed operations vary according to data types. Data is stored in tables in a database. Each column of a data table specifies a data type and data must be stored according to data types.

GaussDB supports implicit conversions between certain data types. For details, see PG_CAST.

• Numeric Types
  
• Monetary Types
  
• Boolean Types
  
• Character Types
  
• Binary Types
  
• Date/Time Types
  
• Geometric Types
  
• Network Address Types
  
• Bit String Types
  
• UUID Type
  
• JSON/JSONB Types
  
• HLL Type
  
• Range Types
  
• Object Identifier Types
  
• Pseudo-Types
  
• XML Types
  
• XMLType
  
• Data Types Used by the Ledger Database
  
• SET Type
  
• ACLItem Type
  
• Array Types
  
• Vector Data Types
  
• Data Types Supported by the Vectorized Executor