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

\d+ mytable will give you the comments for it

For system tables just do

\d+ pg_** substitute ** for system table name

HTH
On Fri, 23 Aug 2002, Marcus Claesson wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Darren Ferguson