Re: new interface

On Fri, 2002-12-06 at 09:55, Reggie Burnett wrote:
> I'm working on a new interface to PostgreSQL and having a difficult
> time. Perhaps someone here can shed some light on the subject.
>
> 1.  Am I correct in thinking that the OID that I receive with the
> RowDescription is the column type?  I have several of those defined from

The OID is just a relatively unique database wide row marker -- which
you cannot count on existing in user tables.  Nothing more or less.  In
some of the system tables it is used as a foreign key to records in
other system tables, but Oid by itself has no such meaning.

>
> I have read through all the docs/faqs I can find and still have no good
> idea about this.

Take a look at the 'System Catalog' documentation, and in psql the -E
option will show you the 'system' queries used to retrieve the
information for display in psql.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc