Re: pg_description usage pointers?

On Mon, Mar 19, 2001 at 09:50:20PM -0500, Bruce Momjian wrote:
> Psql backslash commands use it to describe tables, types, functions,
> etc.

i realize that, coach. i'm wondering if any devious minds
out there are using it for something clever and useful,
instead of doing the roll-your-own table cross-lookups that
i've been hobbling together for the past few weeks...

> > anybody using the PG_DESCRIPTION table to useful effect?
> > if so, or even if not, anybody got some ideas on what you
> > can do with it?

it's used in the psql "\d+" results, of course, but i was
wondering if any of you twisted puppies have used it for
anything more powerful and sinister...?

> > psql=> \h comment
> >
> > Command: COMMENT
> > Description: Add comment to an object
> > Syntax:
> > COMMENT ON
> > [
> > [ DATABASE | INDEX | RULE | SEQUENCE | TABLE | TYPE | VIEW ]
> > object_name |
> > COLUMN table_name.column_name|
> > AGGREGATE agg_name agg_type|
> > FUNCTION func_name (arg1, arg2, ...)|
> > OPERATOR op (leftoperand_type rightoperand_type) |
> > TRIGGER trigger_name ON table_name
> > ] IS 'text'
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!