| From: | "Joel Burton" <jburton(at)scw(dot)org> |
|---|---|
| To: | Nancy Ellman <nan(at)cs(dot)yale(dot)edu> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Where do COMMENTs on columns go? |
| Date: | 2000-12-04 22:02:03 |
| Message-ID: | 3A2BCE0B.14212.1760723@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(at)scw(dot)org
Support Center of Washington (www.scw.org)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-12-04 22:03:21 | Re: Re: [NOVICE] Password protection? |
| Previous Message | Tom Lane | 2000-12-04 21:57:00 | Re: "temporary" table is still there |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roderick A. Anderson | 2000-12-04 22:34:55 | Re: Where do COMMENTs on columns go? |
| Previous Message | Joel Burton | 2000-12-04 22:00:30 | Re: PostgreSQL ODBC driver: recordset not updatable |