Retrieving a column comment
| От | Oliver Kohll |
|---|---|
| Тема | Retrieving a column comment |
| Дата | |
| Msg-id | 200310262202.22396.oliver@gtwebmarque.com обсуждение исходный текст |
| Ответы |
Re: Retrieving a column comment
|
| Список | pgsql-general |
Hi,
I can't seem to retrieve a comment on a table column. The following copy from
psql should I think return a comment:
====================
mydatabase=> COMMENT ON COLUMN car.manufacturer IS 'manufacturer name';
COMMENT
mydatabase=> SELECT relnamespace FROM pg_class WHERE relname='car';
relnamespace
--------------
2200
(1 row)
mydatabase=> SELECT col_description(2200,1);
col_description
-----------------
(1 row)
====================
i.e. it just returns a blank row.
The col_description is described at
http://www.postgresql.org/docs/7.3/static/functions-misc.html
The field number supplied above '1' is right if the first col in a table is
'0', in fact no number I've tried returns anything.
I can't seem to find any examples at all on the web about retrieving column
COMMENTs. Has anyone done this? Postgres version is 7.3
Regards,
Oliver Kohll
GT webMarque
--
В списке pgsql-general по дате отправления: