Re: See the WHERE clause of a partial index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: See the WHERE clause of a partial index
Date: 2012-09-14 19:18:43
Message-ID: 19433.1347650323@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Jungwirth <pj(at)illuminatedcomputing(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-09-14 19:36:19 Re: How to access the extension's operator installed with schema ?
Previous Message Paul Jungwirth 2012-09-14 18:53:07 See the WHERE clause of a partial index