From: Joel Burton <jburton@scw.org>
To: Nancy Ellman <nan@cs.yale.edu>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [GENERAL] Where do COMMENTs on columns go?
Date: Mon, 4 Dec 2000 17:02:03 -0500
Message-ID: <3A2BCE0B.14212.1760723@localhost> (raw)
In-Reply-To: <Pine.LNX.4.21.0012041358220.24374-100000@pine.cs.yale.edu>
> 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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jburton@scw.org, nan@cs.yale.edu
Subject: Re: [GENERAL] Where do COMMENTs on columns go?
In-Reply-To: <3A2BCE0B.14212.1760723@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox