Re: Get info about the index - Mailing list pgsql-general

On Fri, Aug 1, 2025 at 8:06 PM Igor Korot <ikorot01@gmail.com> wrote:
>
> If I read the docs correctly, this field indicates whether the
> WHERE condition is actually present.
>

Are you referring to the condition on a partial index? You can get
that using pg_get_expr():

select pg_get_expr(indpred, indrelid) from pg_index where indexrelid =
'my_partial_index'::regclass;

- Jon