Thread: discovering an index definition
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 |
+---------------------------------------------------------+
Ron Johnson <ron.l.johnson@cox.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
regards, tom lane
On Thu, 2002-05-23 at 23:27, Tom Lane wrote: > Ron Johnson <ron.l.johnson@cox.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.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 | +---------------------------------------------------------+