Cool! Thx :D Bart van Houdt Syfact International B.V. Database developer
-----Original Message----- From: Mario Splivalo [mailto:[EMAIL PROTECTED] 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 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
