> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Albe Laurenz > Sent: Tuesday, March 18, 2008 1:24 AM > To: AlannY *EXTERN*; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
