On 2006-12-06, Timasmith <timasmith@hotmail.com> wrote:
> While pg_catalog.pg_index has the create index script I otherwise cant
> find the index columns in the information_schema.
That's because there are no index columns in the information_schema.
Indexes simply do not exist in SQL (they are merely an implementation
detail) and therefore are not included in information_schema (which is
defined by the SQL spec).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services