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

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.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Hay que recordar que la existencia en el cosmos, y particularmente la
elaboración de civilizaciones dentre de él no son, por desgracia,
nada idílicas" (Ijon Tichy)