Re: [HACKERS] getting index columns from information_schema?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Timasmith <timasmith(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] getting index columns from information_schema?
Date: 2006-12-04 17:33:02
Message-ID: 1165253582.25371.25.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-04 18:19:03 Re: Bundle of patches
Previous Message Andrew Hammond 2006-12-04 16:56:52 Re: postgresql roadmap for horizontal scalability?

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-12-04 17:39:29 Re: PG Admin
Previous Message Bob Pawley 2006-12-04 17:32:28 PG Admin