Re: Getting comments from schema using SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: google(at)jessehersch(dot)fastmail(dot)fm
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Getting comments from schema using SQL
Date: 2007-01-30 01:39:23
Message-ID: 22622.1170121163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

google(at)jessehersch(dot)fastmail(dot)fm writes:
> On Jan 29, 2:40 pm, "Timasmith" <timasm(dot)(dot)(dot)(at)hotmail(dot)com> wrote:
>> What query can I run to get the comments on my table columns using
>> SQL?

> check out the pg_description system catalog:
> http://www.postgresql.org/docs/8.2/static/catalog-pg-description.html

Also see obj_description() and friends, which are basically wrappers
for queries on that catalog:
http://www.postgresql.org/docs/8.2/static/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-01-30 01:52:26 Re: Modifying and solidifying contrib
Previous Message Jim Buttafuoco 2007-01-30 00:48:13 Re: How to configure Postgres to make it not to use (load) crypto libraries.