| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Dann Corbit *EXTERN*" <DCorbit(at)connx(dot)com>, "AlannY *EXTERN*" <m(at)alanny(dot)ru>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Get index information from information_schema? |
| Date: | 2008-03-21 11:20:32 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C201E6713A@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-03-21 11:50:55 | Re: dynamically generated SQL and planner/performance |
| Previous Message | Albe Laurenz | 2008-03-21 11:15:19 | Re: dynamically generated SQL and planner/performance |