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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
