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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part