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.