Re: Table & Column descriptions

That is exactly what I was looking for. Thanks a lot.

Dale.

>>> "Joel Burton" <jburton(at)scw(dot)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(at)scw(dot)org
Support Center of Washington (www.scw.org)