1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
| /**
| * Following query was used to generate this file:
|
| SELECT json_object_agg(UPPER(PT.typname), PT.oid::int4 ORDER BY pt.oid)
| FROM pg_type PT
| WHERE typnamespace = (SELECT pgn.oid FROM pg_namespace pgn WHERE nspname = 'pg_catalog') -- Take only builting Postgres types with stable OID (extension types are not guaranted to be stable)
| AND typtype = 'b' -- Only basic types
| AND typelem = 0 -- Ignore aliases
| AND typisdefined -- Ignore undefined types
| */
|
| module.exports = {
| BOOL: 16,
| BYTEA: 17,
| CHAR: 18,
| INT8: 20,
| INT2: 21,
| INT4: 23,
| REGPROC: 24,
| TEXT: 25,
| OID: 26,
| TID: 27,
| XID: 28,
| CID: 29,
| JSON: 114,
| XML: 142,
| PG_NODE_TREE: 194,
| SMGR: 210,
| PATH: 602,
| POLYGON: 604,
| CIDR: 650,
| FLOAT4: 700,
| FLOAT8: 701,
| ABSTIME: 702,
| RELTIME: 703,
| TINTERVAL: 704,
| CIRCLE: 718,
| MACADDR8: 774,
| MONEY: 790,
| MACADDR: 829,
| INET: 869,
| ACLITEM: 1033,
| BPCHAR: 1042,
| VARCHAR: 1043,
| DATE: 1082,
| TIME: 1083,
| TIMESTAMP: 1114,
| TIMESTAMPTZ: 1184,
| INTERVAL: 1186,
| TIMETZ: 1266,
| BIT: 1560,
| VARBIT: 1562,
| NUMERIC: 1700,
| REFCURSOR: 1790,
| REGPROCEDURE: 2202,
| REGOPER: 2203,
| REGOPERATOR: 2204,
| REGCLASS: 2205,
| REGTYPE: 2206,
| UUID: 2950,
| TXID_SNAPSHOT: 2970,
| PG_LSN: 3220,
| PG_NDISTINCT: 3361,
| PG_DEPENDENCIES: 3402,
| TSVECTOR: 3614,
| TSQUERY: 3615,
| GTSVECTOR: 3642,
| REGCONFIG: 3734,
| REGDICTIONARY: 3769,
| JSONB: 3802,
| REGNAMESPACE: 4089,
| REGROLE: 4096
| };
|
|
