AlannY <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
