From: | "Bart van Houdt" <bart(dot)van(dot)houdt(at)syfact(dot)com> |
---|---|
To: | "Mario Splivalo" <mario(dot)splivalo(at)megafon(dot)hr>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Postgres version of all_ind_cols |
Date: | 2008-11-11 14:04:26 |
Message-ID: | CECE69D480C32F49891F27ED3E49C38C04942287@nthvsexch02.interaccess.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Cool!
Thx :D
Bart van Houdt
Syfact International B.V.
Database developer
-----Original Message-----
From: Mario Splivalo [mailto:mario(dot)splivalo(at)megafon(dot)hr]
Sent: dinsdag 11 november 2008 15:03
To: pgsql-sql(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2008-11-11 14:04:36 | Re: Postgres version of all_ind_cols |
Previous Message | Mario Splivalo | 2008-11-11 14:02:43 | Re: Postgres version of all_ind_cols |