On Mar 18, 2008, at 1:28 PM, Dann Corbit wrote:
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] 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?
Only if they are PRIMARY KEY or UNIQUE indexes.
Erik Jones
DBA | Emma®
[EMAIL PROTECTED]
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
