Thread: Get info about indexes
Hello, there. I need a method of extracting information about indexes of any table from information_schema. Have you any suggestions? Thank you.
AlannY <m@alanny.ru> writes: > I need a method of extracting information about indexes of any table > from information_schema. There is nothing about indexes in the information_schema (this is not a bug, it's an intentional decision by the standards committee). If you want to know about indexes you'll need to look directly at the system catalogs. You can find out about unique/primary-key constraints from information_schema, but that's not quite the same ... regards, tom lane
am Mon, dem 17.03.2008, um 17:07:20 +0300 mailte AlannY folgendes: > Hello, there. > > I need a method of extracting information about indexes of any table > from information_schema. > > Have you any suggestions? Yes, http://www.alberton.info/postgresql_meta_info.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net