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 Name	Implemented	Aliases
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 Name	Implemented
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 Name	Supported
oid	✅
xid	🟠
regclass	✅
regcollation	❌
regconfig	❌
regdictionary	❌
regnamespace	❌
regoper	❌
regoperator	❌
regproc	✅
regprocedure	❌
regrole	❌
regtype	✅