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 };