Postgres version of all_ind_cols

From: "Bart van Houdt" <bart(dot)van(dot)houdt(at)syfact(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Postgres version of all_ind_cols
Date: 2008-11-11 13:57:20
Message-ID: CECE69D480C32F49891F27ED3E49C38C0494226C@nthvsexch02.interaccess.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

This might be a stupid question, but I wasn't able to find any information on it, so here it goes:
Oracle knows a view which contains information about indexed columns (all_ind_cols), is there something similar available in Postgres?

I want to be able to create an full overview of each column with the following information:
- index name
- table name the index is on
- column name the index is on
- column position in the index
- sort order

Any help would be much appreciated :)

Regards,

Bart van Houdt
Syfact International B.V.
Database developer

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2008-11-11 14:02:43 Re: Postgres version of all_ind_cols
Previous Message Mario Splivalo 2008-11-11 11:27:45 Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns