Data Types

Currently, the following data types are supported:

  • bool: boolean type that can hold two values: true and false
  • int4,int,integer: 32-bit integer type
  • int8,bigint: 64-bit integer type
  • float4: float with a precision of 32-bit
  • float8: float with a precision of 64-bit
  • decimal(p,s): decimal type with precision p and scale s
  • string: string type (utf8, but string operations currently only assume ASCII)
  • char(length): char type, length must be <=8
  • date: stores date
  • interval: stores an time interval