getting index columns from information_schema?

Started by Timasmithabout 19 years ago2 messages
#1Timasmith
timasmith@hotmail.com

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.

#2Jeff Davis
pgsql@j-davis.com
In reply to: Timasmith (#1)
Re: [HACKERS] getting index columns from information_schema?

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