public inbox for [email protected]help / color / mirror / Atom feed
Get info about the index 3+ messages / 3 participants [nested] [flat]
* Get info about the index @ 2025-07-26 15:00 Igor Korot <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Igor Korot @ 2025-07-26 15:00 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> 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. Thank you. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Get info about the index @ 2025-07-26 15:15 Adrian Klaver <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2025-07-26 15:15 UTC (permalink / raw) To: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> On 7/26/25 08:00, Igor Korot 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. FYI, pg_class: https://www.postgresql.org/docs/current/catalog-pg-class.html and pg_attribute: https://www.postgresql.org/docs/current/catalog-pg-attribute.html also have index information. > > Thank you. > > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Get info about the index @ 2025-07-26 15:19 Tom Lane <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2025-07-26 15:19 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> Adrian Klaver <[email protected]> writes: > On 7/26/25 08:00, Igor Korot wrote: >> Is there a better place to get the info about the index other than >> https://www.postgresql.org/docs/current/view-pg-indexes.html > pg_class: > https://www.postgresql.org/docs/current/catalog-pg-class.html > and pg_attribute: > https://www.postgresql.org/docs/current/catalog-pg-attribute.html > also have index information. pg_index is the real source of truth here. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-26 15:19 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-26 15:00 Get info about the index Igor Korot <[email protected]> 2025-07-26 15:15 ` Adrian Klaver <[email protected]> 2025-07-26 15:19 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox