| From: | decibel <decibel(at)decibel(dot)org> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Ricardo Bessa <ricardobessa(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Show method of index |
| Date: | 2009-05-19 03:03:11 |
| Message-ID: | 31A07E93-DBCF-4343-9E99-434F1589DDBC@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-05-19 03:25:21 | Re: Show method of index |
| Previous Message | Tom Lane | 2009-05-18 23:10:35 | Re: Proposal: functions get_text() or get_url() |