Re: Get info about the index

From: Jon Zeppieri <zeppieri(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: 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-07-26 19:50:53
Message-ID: CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> I didn't find the sorting for the field.
>
> Can you help?

The pg_index_column_has_property() can provide this information. E.g.,

select pg_index_column_has_property('my_index'::regclass, 2, 'desc');

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DINESH NAIR 2025-07-28 06:06:54 Re: Regarding logical replication issues with PostgreSQL versions 16 and above
Previous Message Laurenz Albe 2025-07-26 19:50:20 Re: Get info about the index