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.
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 |
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 |