Search Postgresql Archives

How can I select a comment on a column?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi community,
I'd like to retrieve comments on tables an columns by table name and column name. The posting by Tom Lane <tgl ( at ) sss ( dot ) pgh ( dot ) pa ( dot ) us>
http://archives.postgresql.org/pgsql-novice/2004-01/msg00180.php?adv=1
says how to select comment on a column.

regression=# create table mytab (mycol int);
CREATE TABLE
regression=# comment on column mytab.mycol is 'my comment';
COMMENT
regression=# select col_description('mytab'::regclass, 1);
 col_description
-----------------
 my comment
(1 row)


How can I now retrieve column number from column name?

Thanks in advance,
Serguei Pronkine


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux