Re: Postgres version of all_ind_cols

Bart van Houdt wrote:
> 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 :)
>

You should check this, for instance:
http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS

There is, also, information_schema in postgres, as well as pg_catalog,
you may wish to check those.

Mike