Skip site navigation (1) Skip section navigation (2)

Re: SQL to get a table columns comments?

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-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      512.569.9461 (cell)

In response to

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group