Dann Corbit wrote: > > > I need a method of extracting information about indexes of any table > > > from information_schema. > > > > > > Have you any suggestions? > > > > I am afraid that indexes are not covered by information_schema. > > > > You'd have to dig into pg_catalog.pg_index for this. > > Doesn't the PostgreSQL schema have the > INFORMATION_SCHEMA.KEY_COLUMN_USAGE view? > > Or (conversely) are indexes not stored as constraints?
You will find constraints in information_schema, but not indexes. In general, indexes are no constraints. Some constraints are implemented as indexes (primary key, unique), but that's a different story. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
