Re: Finding column using SQL query.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Rajan Bhide <rbhide(at)starentnetworks(dot)com>
Cc: email(at)juergen-cappel(dot)de, pgsql-novice(at)postgresql(dot)org, Santosh Bhujbal <sbhujbal(at)starentnetworks(dot)com>
Subject: Re: Finding column using SQL query.
Date: 2005-02-09 16:10:42
Message-ID: 20050209161041.GA92292@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-02-09 16:10:57 Re: Last ID Problem
Previous Message Stephan Szabo 2005-02-09 14:51:37 Re: Problem with alias/case in query