| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Timasmith <timasmith(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SQL to get a table columns comments? |
| Date: | 2007-02-02 03:46:48 |
| Message-ID: | F8691649-3414-48F9-A0EF-F4828100790E@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Jan 27, 2007, at 8:57 PM, Timasmith wrote:
> What query can I run to get the comments for my table columns.
>
> i.e. the ones on my 8.1 database added with this command:
>
> COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
> addresses table';
There's a function that allows you to do that; see the 'System
Information Functions' section of the docs.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2007-02-02 03:47:13 | Re: Postgres SQL Syntax |
| Previous Message | Jim Nasby | 2007-02-02 03:38:07 | Re: Index bloat of 4x |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-02-02 03:50:12 | Re: Enums patch v2 |
| Previous Message | Jeremy Drake | 2007-02-02 03:29:35 | Re: [HACKERS] writing new regexp functions |