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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to