discovering an index definition - Mailing list pgsql-novice

From Ron Johnson
Subject discovering an index definition
Date
Msg-id 1022196698.23957.2.camel@rebel
Whole thread Raw
Responses Re: discovering an index definition  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

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?

test2=# \di i_lane_tx_tmp
       List of relations
     Name      | Type  | Owner
---------------+-------+-------
 i_lane_tx_tmp | index | me
(1 row)

This isn't enough information...

TIA,
Ron
--
+---------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.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                                  |
+---------------------------------------------------------+


pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: COPY returns Bad timestamp external rep..
Next
From: Ron Johnson
Date:
Subject: Re: COPY returns Bad timestamp external rep..