Thread: PQftype()
Where do get a listing of what PQftype() can return to me? (that is what type the field/col has, need a list of Oid's i believe) Magnus -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Programmer/Networker [|] Magnus NaeslundPGP Key: http://www.genline.nu/mag_pgp.txt -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Magnus Naeslund\(f\)" <mag@fbab.net> writes:
> Where do get a listing of what PQftype() can return to me?
select oid, typname from pg_type
regards, tom lane
From: "Tom Lane" <tgl@sss.pgh.pa.us> > "Magnus Naeslund\(f\)" <mag@fbab.net> writes: > > Where do get a listing of what PQftype() can return to me? > > select oid, typname from pg_type > > regards, tom lane Does these change often? Or could i do like the ODBC driver, autogenerate a .h out of that table. Magnus -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Programmer/Networker [|] Magnus NaeslundPGP Key: http://www.genline.nu/mag_pgp.txt -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
From: "Tom Lane" <tgl@sss.pgh.pa.us> [snip] > > The system type OIDs are stable. User-defined types would probably have > a new OID after a dump and reload. > > > Or could i do like the ODBC driver, autogenerate a .h out of that table. > > I would not recommend relying on compiled-in OID knowledge for any types > other than the system-defined datatypes. If you expect to have to deal > with user-defined types, it's best to cache the results of pg_type > lookups at the client end. You need not worry about OIDs changing > during a single client connection. > > regards, tom lane > Ok, then i can use static thing for my application (for now atleast). Thanks.. Magnus
"Magnus Naeslund\(f\)" <mag@fbab.net> writes:
> Where do get a listing of what PQftype() can return to me?
>>
>> select oid, typname from pg_type
> Does these change often?
The system type OIDs are stable. User-defined types would probably have
a new OID after a dump and reload.
> Or could i do like the ODBC driver, autogenerate a .h out of that table.
I would not recommend relying on compiled-in OID knowledge for any types
other than the system-defined datatypes. If you expect to have to deal
with user-defined types, it's best to cache the results of pg_type
lookups at the client end. You need not worry about OIDs changing
during a single client connection.
regards, tom lane