Re: how to find index columns

Andrew - Supernews wrote:
> On 2006-12-06, Timasmith <timasmith(at)hotmail(dot)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

So because it is not in the SQL spec you think that is a good reason
not to have indexes?

Or you think that we do not need that information in order to compare
to databases and create a DDL script to sync the two?