> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Albe Laurenz
> Sent: Tuesday, March 18, 2008 1:24 AM
> To: AlannY *EXTERN*; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Get index information from information_schema?
>
> AlannY 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?