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

From Peter Gibbs
Subject Re: How to retrieve a comment/description from a table
Date
Msg-id 007001c24ab9$0175d5a0$0b01010a@emkel.co.za
Whole thread Raw
In response to Re: How to retrieve a comment/description from a table  (Darren Ferguson <darren@crystalballinc.com>)
List 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to retrieve a comment/description from a table
Next
From: Bruce Momjian
Date:
Subject: Re: Mysql -> PgSQL