Re: Get info about the index

From: Jon Zeppieri <zeppieri(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, David Barbour <david(dot)barbour(at)amiralearning(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Get info about the index
Date: 2025-08-02 00:27:38
Message-ID: CAKfDxxy7ozvUj1mWCZRM=-L5z00S8wXUW+d1KKw56nG+yXo0MA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 1, 2025 at 8:06 PM Igor Korot <ikorot01(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2025-08-02 03:50:15 Re: Get info about the index
Previous Message Adrian Klaver 2025-08-02 00:13:32 Re: Get info about the index