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@candle.pha.pa.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@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!