Re: Get info about indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Get info about indexes
Date
Msg-id 9999.1205767339@sss.pgh.pa.us
Whole thread Raw
In response to Get info about indexes  (AlannY <m@alanny.ru>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "sathiya psql"
Date:
Subject: postgresql performance tuning tools
Next
From: Erik Jones
Date:
Subject: Re: shared memory/max_locks_per_transaction error