Postgres Pro
Downloads
Home   >   mailing lists

Re: Get index information from information_schema? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Get index information from information_schema?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C201E03810@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Get index information from information_schema?  (AlannY <m@alanny.ru>)
Responses Re: Get index information from information_schema?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
Tree view 
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.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: wstrzalka
Date:
Subject: Feature request/suggestion - CREATE SCHEMA LIKE
Next
From: Joris Dobbelsteen
Date:
Subject: Re: Feature request/suggestion - CREATE SCHEMA LIKE