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