Re: Get info about the index

[Jon Zeppieri <zeppieri@xxxxxxxxx>]

On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikorot01@xxxxxxxxx> 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');