Data Types

The numeric, string, temporal, boolean, binary, and complex types, with their storage and casting behaviour.

Binary

• BINARY
• BIT
• VARBIT

Boolean

• BOOLEAN

Complex

• ARRAY
• BOX
• CIRCLE
• DATERANGE
• INT4RANGE
• INT8RANGE
• JSON
• JSONB
• LINE
• LSEG
• MAP
• NUMRANGE
• PATH
• POINT
• POLYGON
• RECORD
• REFCURSOR
• STRUCT
• TSRANGE
• TSTZRANGE
• VOID

Numeric

• BIGINT
• BIGSERIAL
• DECIMAL
• DOUBLE
• FLOAT
• INT
• MONEY
• OID
• REAL
• SERIAL
• SMALLINT
• SMALLSERIAL
• TINYINT

String

• CHAR
• CIDR
• INET
• MACADDR
• MACADDR8
• REGCLASS
• REGPROC
• REGTYPE
• STRING
• TSQUERY
• TSVECTOR
• UUID
• VARCHAR
• XML

Temporal

• DATE
• INTERVAL
• TIME
• TIME WITH TIME ZONE
• TIMESTAMP
• TIMESTAMP_NTZ