Data Type

Data type is a basic attribute of data that used to distinguish different types of data. Different data types occupy different storage space and support different operations. Data is stored in data tables in the 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 Types
  
• Range Types
  
• Object Identifier Types
  
• Pseudo-Types
  
• XML Type
  
• XMLType
  
• ACLItem
  
• Array Types