Обсуждение: Postgres Object Identifiers

Поиск
Список
Период
Сортировка

Postgres Object Identifiers

От
"Vilson farias"
Дата:
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

От
Tom Lane
Дата:
"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