Value | Meaning |
---|---|
BOOL16 | |
BOOL_ARRAY1000 | |
INT221 | |
INT2_ARRAY1005 | |
INT423 | |
INT4_ARRAY1007 | |
INT820 | |
INT8_ARRAY1016 | |
FLOAT4700 | |
FLOAT4_ARRAY1021 | |
FLOAT8701 | |
FLOAT8_ARRAY1022 | |
NUMERIC1700 | |
NUMERIC_ARRAY1231 | |
MONEY790 | |
MONEY_ARRAY791 | |
BIT1560 | |
BIT_ARRAY1561 | |
VARBIT1562 | |
VARBIT_ARRAY1563 | |
CHAR18 | |
CHAR_ARRAY1002 | |
VARCHAR1043 | |
VARCHAR_ARRAY1015 | |
BPCHAR1042 | |
BPCHAR_ARRAY1014 | |
TEXT25 | |
TEXT_ARRAY1009 | |
NAME19 | |
NAME_ARRAY1003 | |
DATE1082 | |
DATE_ARRAY1182 | |
TIME1083 | |
TIME_ARRAY1183 | |
TIMETZ1266 | |
TIMETZ_ARRAY1270 | |
TIMESTAMP1114 | |
TIMESTAMP_ARRAY1115 | |
TIMESTAMPTZ1184 | |
TIMESTAMPTZ_ARRAY1185 | |
INTERVAL1186 | |
INTERVAL_ARRAY1187 | |
BYTEA17 | |
BYTEA_ARRAY1001 | |
MACADDR829 | |
INET869 | |
CIDR650 | |
MACADDR8774 | |
UUID2950 | |
UUID_ARRAY2951 | |
JSON114 | |
JSON_ARRAY199 | |
JSONB3802 | |
JSONB_ARRAY3807 | |
XML142 | |
XML_ARRAY143 | |
POINT600 | |
POINT_ARRAY1017 | |
LINE628 | |
LINE_ARRAY629 | |
LSEG601 | |
LSEG_ARRAY1018 | |
BOX603 | |
BOX_ARRAY1020 | |
PATH602 | |
PATH_ARRAY1019 | |
POLYGON604 | |
POLYGON_ARRAY1027 | |
CIRCLE718 | |
CIRCLE_ARRAY719 | |
HSTORE33670 | |
OID26 | |
OID_ARRAY1028 | |
VOID2278 | |
UNKNOWN705 |
PostgreSQL <a href="https://github.com/postgres/postgres/blob/master/src/include/catalog/pg_type.h">object identifiers (OIDs)</a> for data types
@author <a href="mailto:emad.albloushi@gmail.com">Emad Alblueshi</a>