Re: Retrieving a column comment - Mailing list pgsql-general

From Tom Lane
Subject Re: Retrieving a column comment
Date
Msg-id 933.1067279203@sss.pgh.pa.us
Whole thread Raw
In response to Re: Retrieving a column comment  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> On Sun, Oct 26, 2003 at 10:02:22PM +0000, Oliver Kohll wrote:
>> I can't seem to retrieve a comment on a table column. The following copy from
>> psql should I think return a comment:
>>
>> mydatabase=> SELECT relnamespace FROM pg_class WHERE relname='car';
>> relnamespace
>> --------------
>> 2200
>> (1 row)

> Try using relfilenode instead of relnamespace.

Actually what he wants is the oid.  relfilenode is not relevant to
anything except the table's disk file name.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: PostgreSQL with MS Query?
Next
From: Mike Benoit
Date:
Subject: Re: SCSI vs. IDE performance test