Skip to content

Instantly share code, notes, and snippets.

@sparebytes
Created July 11, 2018 18:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sparebytes/f94867c15059a61ef69dd1882b36c1f6 to your computer and use it in GitHub Desktop.
Save sparebytes/f94867c15059a61ef69dd1882b36c1f6 to your computer and use it in GitHub Desktop.
export enum pgTypeOids {
aclitem = 1033,
bpchar = 1042,
varchar = 1043,
date = 1082,
time = 1083,
timestamp = 1114,
json = 114,
timestamptz = 1184,
interval = 1186,
timetz = 1266,
xml = 142,
bit = 1560,
varbit = 1562,
bool = 16,
bytea = 17,
numeric = 1700,
refcursor = 1790,
char = 18,
name = 19,
int8 = 20,
int2 = 21,
smgr = 210,
int2vector = 22,
regprocedure = 2202,
regoper = 2203,
regoperator = 2204,
regclass = 2205,
regtype = 2206,
record = 2249,
cstring = 2275,
any = 2276,
anyarray = 2277,
void = 2278,
trigger = 2279,
language_handler = 2280,
internal = 2281,
opaque = 2282,
anyelement = 2283,
int4 = 23,
regproc = 24,
text = 25,
oid = 26,
tid = 27,
anynonarray = 2776,
xid = 28,
cid = 29,
uuid = 2950,
txid_snapshot = 2970,
oidvector = 30,
fdw_handler = 3115,
tsm_handler = 3310,
anyenum = 3500,
tsvector = 3614,
tsquery = 3615,
gtsvector = 3642,
regconfig = 3734,
regdictionary = 3769,
jsonb = 3802,
anyrange = 3831,
event_trigger = 3838,
int4range = 3904,
numrange = 3906,
tsrange = 3908,
tstzrange = 3910,
daterange = 3912,
int8range = 3926,
regnamespace = 4089,
regrole = 4096,
point = 600,
lseg = 601,
path = 602,
box = 603,
polygon = 604,
line = 628,
cidr = 650,
float4 = 700,
float8 = 701,
abstime = 702,
reltime = 703,
tinterval = 704,
unknown = 705,
circle = 718,
money = 790,
macaddr = 829,
inet = 869,
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment