pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere do COMMENTs on columns go?
4+ messages / 4 participants
[nested] [flat]
* Where do COMMENTs on columns go?
@ 2000-12-04 19:17 Nancy Ellman <nan@cs.yale.edu>
2000-12-04 22:02 ` Re: [GENERAL] Where do COMMENTs on columns go? Joel Burton <jburton@scw.org>
2000-12-04 22:34 ` Re: Where do COMMENTs on columns go? Roderick A. Anderson <raanders@tincan.org>
0 siblings, 2 replies; 4+ messages in thread
From: Nancy Ellman @ 2000-12-04 19:17 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] Where do COMMENTs on columns go?
2000-12-04 19:17 Where do COMMENTs on columns go? Nancy Ellman <nan@cs.yale.edu>
@ 2000-12-04 22:02 ` Joel Burton <jburton@scw.org>
1 sibling, 0 replies; 4+ messages in thread
From: Joel Burton @ 2000-12-04 22:02 UTC (permalink / raw)
To: Nancy Ellman <nan@cs.yale.edu>; +Cc: 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@scw.org
Support Center of Washington (www.scw.org)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where do COMMENTs on columns go?
2000-12-04 19:17 Where do COMMENTs on columns go? Nancy Ellman <nan@cs.yale.edu>
@ 2000-12-04 22:34 ` Roderick A. Anderson <raanders@tincan.org>
2000-12-10 21:56 ` Re: Where do COMMENTs on columns go? Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 4+ messages in thread
From: Roderick A. Anderson @ 2000-12-04 22:34 UTC (permalink / raw)
To: Nancy Ellman <nan@cs.yale.edu>; +Cc: pgsql-general@postgresql.org
On Mon, 4 Dec 2000, Nancy Ellman wrote:
> However, while I have been able to see the results of the first
> example with
>
> \dd mytable
Try \d+ mytable
Rod
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where do COMMENTs on columns go?
2000-12-04 19:17 Where do COMMENTs on columns go? Nancy Ellman <nan@cs.yale.edu>
2000-12-04 22:34 ` Re: Where do COMMENTs on columns go? Roderick A. Anderson <raanders@tincan.org>
@ 2000-12-10 21:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2000-12-10 21:56 UTC (permalink / raw)
To: Roderick A. Anderson <raanders@tincan.org>; +Cc: Nancy Ellman <nan@cs.yale.edu>; pgsql-general@postgresql.org
> On Mon, 4 Dec 2000, Nancy Ellman wrote:
>
> > However, while I have been able to see the results of the first
> > example with
> >
> > \dd mytable
>
> Try \d+ mytable
I have added a mention of \d+ to the comment manual page. I realize \dd
and \d+ are kind of confusing bcause one shows table name comment and
the other column comments. Other backslash commands have similar +
options.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-12-10 21:56 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-04 19:17 Where do COMMENTs on columns go? Nancy Ellman <nan@cs.yale.edu>
2000-12-04 22:02 ` Joel Burton <jburton@scw.org>
2000-12-04 22:34 ` Roderick A. Anderson <raanders@tincan.org>
2000-12-10 21:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
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