Re: Show method of index - Mailing list pgsql-hackers

From decibel
Subject Re: Show method of index
Date
Msg-id 31A07E93-DBCF-4343-9E99-434F1589DDBC@decibel.org
Whole thread Raw
In response to Re: Show method of index  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Show method of index
List pgsql-hackers
On May 8, 2009, at 3:43 PM, Alvaro Herrera wrote:
> Well, you can see that with \d on the table, but IMHO this should be
> present on \di too, so +1.
>
> One gripe I had with \d and indexes the other day is that it sucks on
> functional indexes -- it just says "pg_expression_1".


The gripe I have with \d is that the "footnotes" are very hard to  
scan through once you have more than a few things on a table. What  
I'd like to see is a version that provides the same information, but  
in a tabular output.

Thoughts? I don't have time to submit a patch for this, but I could  
probably get CashNetUSA to pay to have it done. :)
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: functions get_text() or get_url()
Next
From: Tom Lane
Date:
Subject: Re: Show method of index