That is exactly what I was looking for. Thanks a lot.
Dale.
>>> "Joel Burton" <jburton@scw.org> 11/30/00 01:29PM >>>
\d+ <tablename> should show you the table schema with comments.
If you're looking for the actual data, it's in pg_description. The
objoid field matches the oid field in pg_attribute (which is the
"fields" table for pgsql).
On 30 Nov 2000, at 11:17, Dale Anderson wrote:
> I am able to add table and column descriptions, and I am also able
> to retrieve the table description. The problem is that I can not
> find a way to retrieve the description comments on table
> columns???? Any assistance would be greatly appreciated.
>
> Dale.
>
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)