Re: Postgres version of all_ind_cols - Mailing list pgsql-sql

From Bart van Houdt
Subject Re: Postgres version of all_ind_cols
Date
Msg-id CECE69D480C32F49891F27ED3E49C38C04942287@nthvsexch02.interaccess.nl
Whole thread Raw
In response to Re: Postgres version of all_ind_cols  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-sql
Cool!
Thx :D

Bart van Houdt
Syfact International B.V.
Database developer

-----Original Message-----
From: Mario Splivalo [mailto:mario.splivalo@megafon.hr] 
Sent: dinsdag 11 november 2008 15:03
To: pgsql-sql@postgresql.org
Cc: Bart van Houdt
Subject: Re: [SQL] 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
availablein 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

pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Postgres version of all_ind_cols
Next
From: "A. Kretschmer"
Date:
Subject: Re: Postgres version of all_ind_cols