asoltysik/unison-db

Handle more postgres datatypes

Opened this issue · 0 comments

A (possibly incomplete) list of unhandled datatypes:

--- (oid, typname)
--     [
--       (1082, "DATE"),
--       (1182, "DATE_ARRAY"),
--       (1083, "TIME"),
--       (1183, "TIME_ARRAY"),
--       (1266, "TIMETZ"),
--       (1270, "TIMETZ_ARRAY"),
--       (1114, "TIMESTAMP"),
--       (1115, "TIMESTAMP_ARRAY"),
--       (1184, "TIMESTAMPTZ"),
--       (1185, "TIMESTAMPTZ_ARRAY"),
--       (17, "BYTEA"),
--       (1001, "BYTEA_ARRAY"),
--       (26, "OID"),
--       (1028, "OID_ARRAY"),
--       (790, "MONEY"),
--       (791, "MONEY_ARRAY"),
--       (1560, "BIT"),
--       (1561, "BIT_ARRAY"),
--       (2278, "VOID"),
--       (1186, "INTERVAL"),
--       (1187, "INTERVAL_ARRAY"),
--       (1562, "VARBIT"),
--       (1563, "VARBIT_ARRAY"),
--       (2950, "UUID"),
--       (2951, "UUID_ARRAY"),
--       (142, "XML"),
--       (143, "XML_ARRAY"),
--       (600, "POINT"),
--       (1017, "POINT_ARRAY"),
--       (603, "BOX"),
--       (3807, "JSONB_ARRAY"),
--       (114, "JSON"),
--       (199, "JSON_ARRAY"),
--       (1790, "REF_CURSOR"),
--       (2201, "REF_CURSOR_ARRAY"),
--       (628, "LINE"),
--       (601, "LSEG"),
--       (602, "PATH"),
--       (604, "POLYGON"),
--       (718, "CIRCLE"),
--       (650, "CIDR"),
--       (869, "INET"),
--       (829, "MACADDR"),
--       (774, "MACADDR8"),
--       (3614, "TSVECTOR"),
--       (3615, "TSQUERY") ]