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 | ✅ |
Last updated