discovering an index definition

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: discovering an index definition
Date: 2002-05-23 23:31:37
Message-ID: 1022196698.23957.2.camel@rebel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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 |
+---------------------------------------------------------+

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Johnson 2002-05-23 23:37:40 Re: COPY returns Bad timestamp external rep..
Previous Message Patrick Hatcher 2002-05-23 23:29:32 Re: COPY returns Bad timestamp external rep..