Re: discovering an index definition

On Thu, 2002-05-23 at 23:27, Tom Lane wrote:
> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> > While "\d foo" will describe all of the fields and their
> > data types for the table foo, how do I do something similar
> > for an index?
>
> \d index

Thanks. After scrounging around the system catalogs, I can
see why that is.

HOWEVER... That it unintuitive in the extreme! To Joe
Programmer, this is an index, not a table...

--
+---------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "I have created a government of whirled peas..." |
| Maharishi Mahesh Yogi, 12-May-2002, |
! CNN, Larry King Live |
+---------------------------------------------------------+