| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | "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 15:12:47 |
| Message-ID: | CAKFQuwYh3Tn7a6umxQ-Pgper=Z9GrTCrvMXqJP5o2ggHtw=BDw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Jul 26, 2025, 08:00 Igor Korot <ikorot01(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-07-26 15:15:11 | Re: Get info about the index |
| Previous Message | Robert Sjöblom | 2025-07-26 15:08:25 | Re: Get info about the index |