Paul Jungwirth <pj@xxxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
