PQftype()

"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 Naeslund
PGP 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

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

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