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

From Oliver Kohll
Subject Re: Retrieving a column comment
Date
Msg-id 200310270013.06851.oliver@gtwebmarque.com
Whole thread Raw
In response to Re: Retrieving a column comment  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
On Sunday 26 October 2003 23:03, Alvaro Herrera wrote:
> 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.

Great, thanks Alvaro. The webpage I found the original code in must have been
wrong but that's it.

Oliver


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Retrieving a column comment
Next
From: Adam Witney
Date:
Subject: Re: shared memory on OS X - 7.4beta4