How to retrieve a comment/description from a table

From: Marcus Claesson <marcus(dot)claesson(at)angiogenetics(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: How to retrieve a comment/description from a table
Date: 2002-08-23 14:22:25
Message-ID: 3D664521.AA6141C0@angiogenetics.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!
This psql command is very straight forward and promising:
COMMENT ON mytable IS 'This is my table.';

But how can I retrieve the particular comment from that table again?
Using \d+ gives you all the tables with their comments. I want a special
one.

And if that is not possible, can the \d+ results be obtained from a
system table or so?

Thanks,
Marcus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-08-23 14:28:44 Re: How to retrieve a comment/description from a table
Previous Message Richard Huxton 2002-08-23 13:42:43 Re: trigger fired on changes in specific column