> -----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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
