Re: Get info about the index

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Igor Korot <ikorot01(at)gmail(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 18:13:48
Message-ID: 0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2025-07-26 19:13:23 Re: Get info about the index
Previous Message Igor Korot 2025-07-26 16:41:48 Re: Get info about the index