Re: Enhanced index details using \d in psql

"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
> By the way, that "Index predicate" at the end of \di output
> is pretty ugly IMO. What is the purpose of it?

It looks like a dump of the internal form of the partial-index
predicate. I don't know where it's coming from, but it's not
in current CVS sources. Using your example I get just

regression=# \d apple
Index "apple"
Column | Type
---------+---------
topping | integer
hash
Index predicate: (topping > 99)

regression=# \di apple
List of relations
Name | Type | Owner
-------+-------+----------
apple | index | postgres
(1 row)

regression=#

which reminds me that I've been misstating in this conversation;
the query that I was thinking about was "\d index" not "\di index".
\di is for a bulk listing of multiple indexes, one per line, so there's
a limit to how much info you can supply per index. I doubt predicates
can be made to fit. It might be worth adding a few columns though,
like name of parent table.

regards, tom lane