Received: from olympus.scw.org (209-9-156-98.sdsl.cais.net [209.9.156.98])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB4M2LG47203
	for <pgsql-interfaces@postgresql.org>;
	Mon, 4 Dec 2000 17:02:21 -0500 (EST) (envelope-from jburton@scw.org)
Received: from hades (eos.scw.org [209.9.156.112])
	by olympus.scw.org (8.10.1/8.10.1) with ESMTP id eB4M21g23961;
	Mon, 4 Dec 2000 17:02:01 -0500
From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: Nancy Ellman <nan@cs.yale.edu>
Date: Mon, 4 Dec 2000 17:02:03 -0500
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: [GENERAL] Where do COMMENTs on columns go?
CC: pgsql-interfaces@postgresql.org
Message-ID: <3A2BCE0B.14212.1760723@localhost>
In-reply-to: <Pine.LNX.4.21.0012041358220.24374-100000@pine.cs.yale.edu>
X-mailer: Pegasus Mail for Win32 (v3.12c)
X-Archive-Number: 200012/26
X-Sequence-Number: 363

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