Re: [HACKERS] getting index columns from information_schema? - Mailing list pgsql-general

From Jeff Davis
Subject Re: [HACKERS] getting index columns from information_schema?
Date
Msg-id 1165253582.25371.25.camel@dogma.v10.wvs
Whole thread Raw
List pgsql-general
On Mon, 2006-12-04 at 07:18 -0800, Timasmith wrote:
> I cant seem to find the right query to retreive the discrete columns,
> column position, for a specified index.
>
> This is towards the purpose of identifying the schema differences
> between two databases and creating the changes needed.
>

Note: this question is appropriate on pgsql-general, not on pgsql-
hackers.

The columns of an index can be found in pg_attribute with an indexrelid
equal to the oid of the index's entry in pg_class.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: novnov
Date:
Subject: Re: Speed of postgres compared to ms sql, is this
Next
From: Bob Pawley
Date:
Subject: PG Admin