Thread: Postgres Object Identifiers

Postgres Object Identifiers

From
"Vilson farias"
Date:
Hi there people!

I'm using the Postgres Client interface from libpq library.
More specifically, one of the functions I'm intending to use is the PQftype
function that prototype is

Oid PQftype(const PGresult *res, int field_index);

And, to use this funcion I need to know what it is returning to me because
I'll need to convert these Oids to types defined in a protocol with the
application.

So, somebody of you knows where can I get the description list of the types
used by Postgres and their object identifers ?

I really appreciate if you can help me

Best regards,



Re: Postgres Object Identifiers

From
Tom Lane
Date:
"Vilson farias" <vilson.farias@digitro.com.br> writes:
> So, somebody of you knows where can I get the description list of the types
> used by Postgres and their object identifers ?
SELECT oid, typname FROM pg_type;
        regards, tom lane