Data types

Numeric types

BIGINT.

INTEGER

Integers

NUMERIC

DECIMAL

Real numbers with specified precision

DOUBLE

FLOAT

Real numbers with variable precision

Text type

VARCHAR

CHAR, BPCHAR, STRING, TEXT

Text strings

Types for date and time

DATE

Dates

TIME

Time

TIMESTAMP.

Time stamps

TIMESTAMPTZ

Time stamps with time zone

JSON type

`JSON'

Data in JSON

Types for arrays

BIGINT[/]

INTEGER[]

Arrays of integers

VARCHAR[/]

CHAR[], BPCHAR[], STRING[], TEXT[]

Arrays of text strings

BOOL[/]

BOOLEAN[]

Arrays of Boolean values

Binary type

`BLOB'

``BYTEA''

Binary objects

Logical type

`BOOL

`BOOLEAN

Boolean values

Type for geodata

GEOMETRY

GEOMETRY

Geospatial data