AlannY <m@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
