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

From: "Peter Gibbs" <peter(at)emkel(dot)co(dot)za>
To: <marcus(dot)claesson(at)angiogenetics(dot)se>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to retrieve a comment/description from a table
Date: 2002-08-23 15:23:17
Message-ID: 007001c24ab9$0175d5a0$0b01010a@emkel.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcus Claesson wrote:

> 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.

select obj_description(oid, 'pg_class')
from pg_class
where relname = 'tablename';
--
Peter Gibbs
EmKel Systems

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-08-23 15:29:33 Re: Mysql -> PgSQL
Previous Message Tom Lane 2002-08-23 15:22:33 Re: How to retrieve a comment/description from a table