\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