epgsql/src/epgsql_types.erl

-module(epgsql_types).

-export([oid2type/1, type2oid/1]).

oid2type(16)   -> bool;
oid2type(17)   -> bytea;
oid2type(18)   -> char;
oid2type(19)   -> name;
oid2type(20)   -> int8;
oid2type(21)   -> int2;
oid2type(22)   -> int2vector;
oid2type(23)   -> int4;
oid2type(24)   -> regproc;
oid2type(25)   -> text;
oid2type(26)   -> oid;
oid2type(27)   -> tid;
oid2type(28)   -> xid;
oid2type(29)   -> cid;
oid2type(30)   -> oidvector;
oid2type(71)   -> pg_type_reltype;
oid2type(75)   -> pg_attribute_reltype;
oid2type(81)   -> pg_proc_reltype;
oid2type(83)   -> pg_class_reltype;
oid2type(142)  -> xml;
oid2type(600)  -> point;
oid2type(601)  -> lseg;
oid2type(602)  -> path;
oid2type(603)  -> box;
oid2type(604)  -> polygon;
oid2type(628)  -> line;
oid2type(650)  -> cidr;
oid2type(651)  -> {array, cidr};
oid2type(700)  -> float4;
oid2type(701)  -> float8;
oid2type(702)  -> abstime;
oid2type(703)  -> reltime;
oid2type(704)  -> tinterval;
oid2type(705)  -> unknown;
oid2type(718)  -> circle;
oid2type(790)  -> cash;
oid2type(829)  -> macaddr;
oid2type(869)  -> inet;
oid2type(1000) -> {array, bool};
oid2type(1005) -> {array, int2};
oid2type(1007) -> {array, int4};
oid2type(1009) -> {array, text};
oid2type(1014) -> {array, char};
oid2type(1015) -> {array, varchar};
oid2type(1016) -> {array, int8};
oid2type(1021) -> {array, float4};
oid2type(1022) -> {array, float8};
oid2type(1033) -> aclitem;
oid2type(1263) -> {array, cstring};
oid2type(1041) -> {array, inet};
oid2type(1042) -> bpchar;
oid2type(1043) -> varchar;
oid2type(1082) -> date;
oid2type(1083) -> time;
oid2type(1114) -> timestamp;
oid2type(1115) -> {array, timestamp};
oid2type(1182) -> {array, date};
oid2type(1183) -> {array, time};
oid2type(1184) -> timestamptz;
oid2type(1185) -> {array, timestamptz};
oid2type(1186) -> interval;
oid2type(1187) -> {array, interval};
oid2type(1266) -> timetz;
oid2type(1270) -> {array, timetz};
oid2type(1560) -> bit;
oid2type(1562) -> varbit;
oid2type(1700) -> numeric;
oid2type(1790) -> refcursor;
oid2type(2202) -> regprocedure;
oid2type(2203) -> regoper;
oid2type(2204) -> regoperator;
oid2type(2205) -> regclass;
oid2type(2206) -> regtype;
oid2type(2211) -> {array, regtype};
oid2type(3614) -> tsvector;
oid2type(3642) -> gtsvector;
oid2type(3615) -> tsquery;
oid2type(3734) -> regconfig;
oid2type(3769) -> regdictionary;
oid2type(2249) -> record;
oid2type(2275) -> cstring;
oid2type(2276) -> any;
oid2type(2277) -> {array, any};
oid2type(2278) -> void;
oid2type(2279) -> trigger;
oid2type(2280) -> language_handler;
oid2type(2281) -> internal;
oid2type(2282) -> opaque;
oid2type(2283) -> anyelement;
oid2type(2776) -> anynonarray;
oid2type(2950) -> uuid;
oid2type(2951) -> {array, uuid};
oid2type(3500) -> anyenum;
oid2type(Oid)  -> {unknown_oid, Oid}.

type2oid(bool)                  -> 16;
type2oid(bytea)                 -> 17;
type2oid(char)                  -> 18;
type2oid(name)                  -> 19;
type2oid(int8)                  -> 20;
type2oid(int2)                  -> 21;
type2oid(int2vector)            -> 22;
type2oid(int4)                  -> 23;
type2oid(regproc)               -> 24;
type2oid(text)                  -> 25;
type2oid(oid)                   -> 26;
type2oid(tid)                   -> 27;
type2oid(xid)                   -> 28;
type2oid(cid)                   -> 29;
type2oid(oidvector)             -> 30;
type2oid(pg_type_reltype)       -> 71;
type2oid(pg_attribute_reltype)  -> 75;
type2oid(pg_proc_reltype)       -> 81;
type2oid(pg_class_reltype)      -> 83;
type2oid(xml)                   -> 142;
type2oid(point)                 -> 600;
type2oid(lseg)                  -> 601;
type2oid(path)                  -> 602;
type2oid(box)                   -> 603;
type2oid(polygon)               -> 604;
type2oid(line)                  -> 628;
type2oid(cidr)                  -> 650;
type2oid({array, cidr})         -> 651;
type2oid(float4)                -> 700;
type2oid(float8)                -> 701;
type2oid(abstime)               -> 702;
type2oid(reltime)               -> 703;
type2oid(tinterval)             -> 704;
type2oid(unknown)               -> 705;
type2oid(circle)                -> 718;
type2oid(cash)                  -> 790;
type2oid(macaddr)               -> 829;
type2oid(inet)                  -> 869;
type2oid({array, bool})         -> 1000;
type2oid({array, int2})         -> 1005;
type2oid({array, int4})         -> 1007;
type2oid({array, text})         -> 1009;
type2oid({array, char})         -> 1014;
type2oid({array, varchar})      -> 1015;
type2oid({array, int8})         -> 1016;
type2oid({array, float4})       -> 1021;
type2oid({array, float8})       -> 1022;
type2oid(aclitem)               -> 1033;
type2oid({array, cstring})      -> 1263;
type2oid({array, inet})         -> 1041;
type2oid(bpchar)                -> 1042;
type2oid(varchar)               -> 1043;
type2oid(date)                  -> 1082;
type2oid(time)                  -> 1083;
type2oid(timestamp)             -> 1114;
type2oid({array, timestamp})    -> 1115;
type2oid({array, date})         -> 1182;
type2oid({array, time})         -> 1183;
type2oid(timestamptz)           -> 1184;
type2oid({array, timestamptz})  -> 1185;
type2oid(interval)              -> 1186;
type2oid({array, interval})     -> 1187;
type2oid(timetz)                -> 1266;
type2oid({array, timetz})       -> 1270;
type2oid(bit)                   -> 1560;
type2oid(varbit)                -> 1562;
type2oid(numeric)               -> 1700;
type2oid(refcursor)             -> 1790;
type2oid(regprocedure)          -> 2202;
type2oid(regoper)               -> 2203;
type2oid(regoperator)           -> 2204;
type2oid(regclass)              -> 2205;
type2oid(regtype)               -> 2206;
type2oid({array, regtype})      -> 2211;
type2oid(tsvector)              -> 3614;
type2oid(gtsvector)             -> 3642;
type2oid(tsquery)               -> 3615;
type2oid(regconfig)             -> 3734;
type2oid(regdictionary)         -> 3769;
type2oid(record)                -> 2249;
type2oid(cstring)               -> 2275;
type2oid(any)                   -> 2276;
type2oid({array, any})          -> 2277;
type2oid(void)                  -> 2278;
type2oid(trigger)               -> 2279;
type2oid(language_handler)      -> 2280;
type2oid(internal)              -> 2281;
type2oid(opaque)                -> 2282;
type2oid(anyelement)            -> 2283;
type2oid(anynonarray)           -> 2776;
type2oid(uuid)                  -> 2950;
type2oid({array, uuid})         -> 2951;
type2oid(anyenum)               -> 3500;
type2oid(Type)                  -> {unknown_type, Type}.