Try
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Get info about the index
Date
Msg-id CAKFQuwYh3Tn7a6umxQ-Pgper=Z9GrTCrvMXqJP5o2ggHtw=BDw@mail.gmail.com
Whole thread Raw
In response to Get info about the index  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view
On Sat, Jul 26, 2025, 08:00 Igor Korot <ikorot01@gmail.com> wrote:
Hi, ALL,
Is there a better place to get the info about the index other than
https://www.postgresql.org/docs/current/view-pg-indexes.html

That guy has a full blown CREATE INDEX command and I will need to
parse it to get the info I need.

Follow the foreign keys.

All useful info does get parsed out into columns somewhere.  The system doesn't parse a create index command everytime it needs to inspect the properties of the index.

David J.

pgsql-general by date:

Previous
From: Robert Sjöblom
Date:
Subject: Re: Get info about the index
Next
From: Adrian Klaver
Date:
Subject: Re: Get info about the index