Re: Get index information from information_schema?

On Mar 18, 2008, at 1:28 PM, Dann Corbit wrote:

>> -----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?

Only if they are PRIMARY KEY or UNIQUE indexes.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com