Where do COMMENTs on columns go? - Mailing list pgsql-general

From Nancy Ellman
Subject Where do COMMENTs on columns go?
Date
Msg-id Pine.LNX.4.21.0012041358220.24374-100000@pine.cs.yale.edu
Whole thread Raw
Responses Re: Where do COMMENTs on columns go?  ("Roderick A. Anderson" <raanders@tincan.org>)
List pgsql-general

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.




pgsql-general by date:

Previous
From: Christian Ullrich
Date:
Subject: Re: Failed regression tests with 7.0.3 on Windows NT 4.0
Next
From: "Joel Burton"
Date:
Subject: Re: [SQL] Access Permissions/Security