pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres Object Identifiers
2+ messages / 2 participants
[nested] [flat]

* Postgres Object Identifiers
@ 2002-10-04 12:32  Vilson farias <vilson.farias@digitro.com.br>
  0 siblings, 1 reply; 2+ messages in thread

From: Vilson farias @ 2002-10-04 12:32 UTC (permalink / raw)
  To: pgsql-interfaces; +Cc: IORRANA, Maria Ribeiro <iorrana.ribeiro@digitro.com.br>

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,




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres Object Identifiers
@ 2002-10-04 14:05  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Vilson farias <vilson.farias@digitro.com.br>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2002-10-04 14:05 UTC (permalink / raw)
  To: Vilson farias <vilson.farias@digitro.com.br>; +Cc: pgsql-interfaces@postgresql.org, "IORRANA, Maria Ribeiro" <iorrana.ribeiro@digitro.com.br>

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-10-04 14:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-04 12:32 Postgres Object Identifiers Vilson farias <vilson.farias@digitro.com.br>
2002-10-04 14:05 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox