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)

In response to

• SQL to get a table columns comments? at 2007-01-28 01:57:06 from Timasmith

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2007-02-02 03:50:12
	Subject: Re: Enums patch v2
Previous:	From: Jeremy Drake	Date: 2007-02-02 03:29:35
	Subject: Re: [HACKERS] writing new regexp functions

pgsql-general by date

Next:	From: Ron Johnson	Date: 2007-02-02 03:47:13
	Subject: Re: Postgres SQL Syntax
Previous:	From: Jim Nasby	Date: 2007-02-02 03:38:07
	Subject: Re: Index bloat of 4x