Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group