According to the documentation for COMMENT, it puts a comment on
object "that can be easily retrieved with psql's \dd command."
Examples like
COMMENT on table mytable is 'foo';
COMMENT on column mytable.mycolumn is 'bar';
are given.
However, while I have been able to see the results of the first
example with
\dd mytable
I have not been able to get \dd to show the comments on the
individual columns.
Can someone tell me how to do that?
I am running postgresql-7.0.2.
Thanks,
Nan Ellman
PS Please email any replies to me directly.