Skip to content

Data Types

Integer types

int, int4, integer, int8, bigint, smallint, tinyint, serial, bigserial, smallserial, tinyserial, serial2, serial4, serial8

Floating point types

real, float4, double precision, float8, numeric, decimal

Boolean types

boolean, bool

String types

char, varchar, text, character, character varying, char varying

Date and time types

date, time, timestamp, timestamp with time zone, timestamp without time zone, timestamptz, timetz, interval

UUID type


JSON type

json, jsonb