Thread: libpq PQftype() to comprehend types?
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? I need to be able to tell what data type a given column is. The 6.3.2 manual says PQftype() returns an internal coding -- is this defined in a header file I can access, or ... ? thanks, Michael
Michael Olivier <mo@local2me.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