Where do COMMENTs on columns go?

From: Nancy Ellman <nan(at)cs(dot)yale(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Where do COMMENTs on columns go?
Date: 2000-12-04 19:17:25
Message-ID: Pine.LNX.4.21.0012041358220.24374-100000@pine.cs.yale.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Ullrich 2000-12-04 19:21:13 Re: Failed regression tests with 7.0.3 on Windows NT 4.0
Previous Message Chris Jones 2000-12-04 18:53:10 "temporary" table is still there

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joel Burton 2000-12-04 19:52:16 Re: PostgreSQL ODBC driver: recordset not updatable
Previous Message Evelio Martinez 2000-12-04 18:44:23 PostgreSQL ODBC driver: recordset not updatable