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 defines the data type. During storage, 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
  
• Text Search Types
  
• UUID Type
  
• JSON/JSONB Types
  
• HLL
  
• Range
  
• Object Identifier Types
  
• Pseudo-Types
  
• Data Types Supported by Column-store Tables
  
• Data Types Used by the Ledger Database
  
• ACLItem