> -----Original Message----- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 9:19 AM > To: Reggie Burnett > Cc: PostgreSQL-development > Subject: Re: [HACKERS] 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.
So if OID can't be counted on to be there 100% of the time, what do I use to index the catalog to determine type, not null-ness, uniqueness, etc? > > > > > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
