Re: How to retrieve a comment/description from a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marcus(dot)claesson(at)angiogenetics(dot)se
Cc: Darren Ferguson <darren(at)crystalballinc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to retrieve a comment/description from a table
Date: 2002-08-23 15:22:33
Message-ID: 27148.1030116153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcus Claesson <marcus(dot)claesson(at)angiogenetics(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Gibbs 2002-08-23 15:23:17 Re: How to retrieve a comment/description from a table
Previous Message Christoph Dalitz 2002-08-23 15:08:04 alter table ad primary key