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.

SQL Type NameImplementedAliases
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#

SQL Type NameImplemented
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.

SQL Type NameSupported
oid✅
xid🟠
regclass✅
regcollation❌
regconfig❌
regdictionary❌
regnamespace❌
regoper❌
regoperator❌
regproc✅
regprocedure❌
regrole❌
regtype✅