| From: | "Joel Burton" <jburton(at)scw(dot)org> |
|---|---|
| To: | "Dale Anderson" <danderso(at)crystalsugar(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Table & Column descriptions |
| Date: | 2000-11-30 19:29:59 |
| Message-ID: | 3A266467.16970.41338C@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
\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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francis Solomon | 2000-11-30 19:39:01 | RE: Can PostGreSQL handle 100 user database? |
| Previous Message | Tom Lane | 2000-11-30 19:24:13 | Re: Help with Database Recovery |