| From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
|---|---|
| To: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "AlannY *EXTERN*" <m(at)alanny(dot)ru>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Get index information from information_schema? |
| Date: | 2008-03-18 18:28:19 |
| Message-ID: | D425483C2C5C9F49B5B7A41F8944154701000D11@postal.corporate.connx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Albe Laurenz
> Sent: Tuesday, March 18, 2008 1:24 AM
> To: AlannY *EXTERN*; pgsql-general(at)postgresql(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2008-03-18 18:39:41 | Re: Feature request/suggestion - CREATE SCHEMA LIKE |
| Previous Message | Stumo | 2008-03-18 18:06:32 | Running function automatically on (unclean) disconnect |