| 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 | Resend email |
| 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
| 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 |
| 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? |