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