Re: Finding column using SQL query.

On Wed, Feb 09, 2005 at 05:13:28PM +0530, Rajan Bhide wrote:
> >
> > pg_attribute.attrelid=pg_class.oid
>
> I am not able to find any attribute name 'oid' for pg_class.

oid is a system column:

http://www.postgresql.org/docs/8.0/static/ddl-system-columns.html

> Is this new in 8.0?

No, earlier versions PostgreSQL also had oid system columns.  The
documentation discourages their use as primary keys in user tables
and says that future versions might disable their creation by default.

http://www.postgresql.org/docs/8.0/static/datatype-oid.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/