DataType

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>

Values

ValueMeaning
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

Meta