getting index columns from information_schema?

From: "Timasmith" <timasmith(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: getting index columns from information_schema?
Date: 2006-12-04 15:18:44
Message-ID: 1165245524.716201.68590@80g2000cwy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-12-04 15:29:42 Re: Locking for function creation
Previous Message Ronin 2006-12-04 14:52:19 pgsql bug found?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-04 15:23:19 Re: Facing a problem with SPI
Previous Message Tom Lane 2006-12-04 15:13:39 Re: Notify enhancement