Try
Home   >   mailing lists

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

From Jon Zeppieri
Subject Re: Get info about the index
Date
Msg-id CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com
Whole thread Raw
In response to Re: Get info about the index  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view 
On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikorot01@gmail.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');

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Get info about the index
Next
From: "DINESH NAIR"
Date:
Subject: Re: Regarding logical replication issues with PostgreSQL versions 16 and above