Re: [GENERAL] Where do COMMENTs on columns go? - Mailing list pgsql-interfaces

From Joel Burton
Subject Re: [GENERAL] Where do COMMENTs on columns go?
Date
Msg-id 3A2BCE0B.14212.1760723@localhost
Whole thread Raw
List pgsql-interfaces
>  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)


pgsql-interfaces by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: jdbc7.0-1.2.jar
Next
From: "Joel Burton"
Date:
Subject: Re: PostgreSQL ODBC driver: recordset not updatable