Adrian, On Sat, Jul 26, 2025 at 11:08 AM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > 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 > > What information do you need?
This is the command for creating the index: https://www.postgresql.org/docs/current/sql-createindex.html. 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 I don't want to parse the command since I'm sure I can query the DB to get the info. Thank you.. > > > > > That guy has a full blown CREATE INDEX command and I will need to > > parse it to get the info I need. > > > > Thank you. > > > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com