Re: Get info about the index

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: 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:13:23
Message-ID: CA+FnnTy8bdXxFZBmFfm1oNMQLVxL-+UmkX8EecbLB0MehX8gFw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, Christopher,

On Sat, Jul 26, 2025, 2:14 PM Christophe Pettus <xof(at)thebuild(dot)com> wrote:

>
>
> > I want to know all individual things:
> > - whether the index is unique.
> > - what type of index it is
> > - whether the field is ASC or DESC.
> > - all other individual arams
>
> pg_index is the source for those. The one exception is the access method
> for the index, which is in pg_class.

I didn't find the sorting for the field.

Can you help?

Thank you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-07-26 19:50:20 Re: Get info about the index
Previous Message Christophe Pettus 2025-07-26 18:13:48 Re: Get info about the index