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 :)
Regards,
Bart van Houdt
Syfact International B.V.
Database developer