Re: Show method of index

Tom Lane escribió:
> David Fetter <david@fetter.org> writes:
> > On Fri, May 08, 2009 at 04:43:44PM -0400, Alvaro Herrera wrote:
> >> One gripe I had with \d and indexes the other day is that it sucks
> >> on functional indexes -- it just says "pg_expression_1".
> 
> > Any ideas for a better naming convention?
> 
> Changing the naming convention seems rather pointless --- I imagine what
> Alvaro was wishing for was that \d would actually show the indexed
> expression(s).

Yeah.  (I note that the expressions are already shown as footers when
you display the table instead of the index.  It seems like the \d code
for indexes did not get updated when that new code was added.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support