Re: How to retrieve a comment/description from a table - Mailing list pgsql-general

Marcus Claesson <marcus.claesson@angiogenetics.se> writes:
> What I wish is to retrieve the comment with a sql question, which would work
> if the '\d+ information' could be found in an actual table somewhere.

The descriptions are kept in pg_description.  Although you can just do
"select from pg_description", the recommended retrieval method is the
obj_description() function.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/functions-misc.html
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/catalog-pg-description.html

            regards, tom lane