Quick Links

SQL to get a table columns comments?

From:	"Timasmith" <timasmith(at)hotmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org pgsql-hackers(at)postgresql(dot)org
Subject:	SQL to get a table columns comments?
Date:	2007-01-28 01:57:06
Message-ID:	1169949426.721522.117610@a75g2000cwd.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-hackers

Hi,

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';

thanks

Tim

Responses

Re: SQL to get a table columns comments? at 2007-01-30 06:32:11 from A. Kretschmer
Re: SQL to get a table columns comments? at 2007-01-30 17:15:11 from codeWarrior
Re: SQL to get a table columns comments? at 2007-02-02 03:46:48 from Jim Nasby

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bruce Momjian	2007-01-28 02:20:00	Re: Password issue revisited
Previous Message	Tom Lane	2007-01-28 01:46:33	Re: Password issue revisited

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David Fetter	2007-01-28 02:01:18	Re: Modifying and solidifying contrib
Previous Message	Jeremy Drake	2007-01-28 00:44:42	Re: [HACKERS] less privileged pl install