Supported Types
Standard Types
Most of the standard types with partial support are missing functionality regarding their parameters. For example, timestamp
takes in a precision, but does not enforce it.
bit
β
bit[]
β
boolean
β
boolean[]
β
box
β
box[]
β
bytea
π
bytea[]
π
char
π
character
char[]
π
character[]
cidr
β
cidr[]
β
circle
β
circle[]
β
date
π
date[]
π
datemultirange
β
daterange
β
float4
β
real
float4[]
β
real[]
float8
β
double precision
float8[]
β
double precision[]
inet
β
inet[]
β
int2
β
smallint
int2[]
β
smallint[]
int4
β
int, integer
int4[]
β
int[], integer[]
int4multirange
β
int4range
β
int8
β
bigint
int8[]
β
bigint[]
int8multirange
β
int8range
β
interval
β
interval[]
β
json
π
json[]
π
jsonb
π
jsonb[]
π
line
β
line[]
β
lseg
β
lseg[]
β
macaddr
β
macaddr8
β
macaddr8[]
β
macaddr[]
β
money
β
money[]
β
numeric
π
decimal
numeric[]
π
decimal[]
nummultirange
β
numrange
β
path
β
path[]
β
point
β
point[]
β
polygon
β
polygon[]
β
serial2
β
smallserial
serial4
β
serial
serial8
β
bigserial
text
β
text[]
β
time
π
time without time zone
time[]
π
time without time zone[]
timestamp
π
timestamp without time zone
timestamp[]
π
timestamp without time zone[]
timestamptz
π
timestamp with time zone
timestamptz[]
π
timestamp with time zone[]
timetz
π
time with time zone
timetz[]
π
time with time zone[]
tsmultirange
β
tsquery
β
tsquery[]
β
tsrange
β
tstzmultirange
β
tstzrange
β
tsvector
β
tsvector[]
β
uuid
β
uuid[]
β
varbit
β
bit varying
varbit[]
β
bit varying[]
varchar
π
character varying
varchar[]
π
character varying[]
xml
β
xml[]
β
Pseudo-Types
any
β
anyarray
β
anycompatible
β
anycompatiblearray
β
anycompatiblemultirange
β
anycompatiblenonarray
β
anycompatiblerange
β
anyelement
β
anyenum
β
anymultirange
β
anynonarray
β
anyrange
β
cstring
β
event_trigger
β
fdw_handler
β
index_am_handler
β
internal
β
language_handler
β
pg_ddl_command
β
record
β
table_am_handler
β
trigger
β
tsm_handler
β
unknown
π
void
β
OID Alias Types
See detailed list in the Postgres docs.
oid
β
xid
π
regclass
β
regcollation
β
regconfig
β
regdictionary
β
regnamespace
β
regoper
β
regoperator
β
regproc
β
regprocedure
β
regrole
β
regtype
β
Last updated