Re: See the WHERE clause of a partial index

Paul Jungwirth <pj@illuminatedcomputing.com> writes:
> I'm not sure how to interpret that `indpred` column. Is there any way
> to reconstruct the WHERE clause I originally passed to the CREATE
> INDEX command?

pg_get_indexdef() should help.  If you really want just the WHERE
clause, possibly pg_get_expr() would work, but I've not tried it on
index clauses.

            regards, tom lane