Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL to get a table columns comments? - Mailing list pgsql-general

From Jim Nasby
Subject Re: SQL to get a table columns comments?
Date
Msg-id F8691649-3414-48F9-A0EF-F4828100790E@decibel.org
Whole thread Raw
In response to SQL to get a table columns comments?  ("Timasmith" <timasmith@hotmail.com>)
List pgsql-general
Tree view 
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@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Defining and Using variables in a postgres function
Next
From: Jim Nasby
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches