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
