Michael Olivier <mo(at)local2me(dot)com> writes:
> Can someone tell me how I can use PQftype() or some other mechanism to
> interpret a query result in terms of the data types of the columns?
The PQftype value is the OID of the row for the type in the system
pg_type catalog. Try
SELECT * FROM pg_type WHERE oid = <PQftype result>
BTW: oid's for the predefined types are consistent across installations,
but oid's for user-defined types are not (and shouldn't even be trusted
across a save/reload).
regards, tom lane
pgsql-interfaces by date
|Next:||From: Ries van Twisk||Date: 1999-03-12 06:32:14|
|Subject: Postgres and ODBC with MS-Access memory problem|
|Previous:||From: Claudio Cicognani||Date: 1999-03-11 18:46:42|
|Subject: Looking for a software library|