Thread: Re: [GENERAL] Where do COMMENTs on columns go?

Re: [GENERAL] Where do COMMENTs on columns go?

From
"Joel Burton"
Date:
>  COMMENT on table mytable is 'foo';
>  COMMENT on column mytable.mycolumn is 'bar';

> I have not been able to get \dd to show the comments on the
> individual columns. 

\d+ <tablename>

In general, the "+" shows the comments.

You need a semi-recent version of psql to do this, something like 
7.0 or better.


--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)