Re: list of index

Hi ,

I have done that. The important point is obtaining the “sort order” of each column in the index. Specially multi column index.

Are there no views?

How does the engine handle sort order of a multi column index?!!

From what I have seen it is rather complicated in postgres.

Any suggestion would be very welcome. Many Thanks.

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Szymon Guz
Sent: 15 August 2014 15:32
To: farjad(dot)farid(at)checknetworks(dot)com
Cc: PostgreSQL
Subject: Re: [GENERAL] list of index

On 15 August 2014 16:23, FarjadFarid(ChkNet) <farjad(dot)farid(at)checknetworks(dot)com> wrote:

Hi ,

On a Postgresql database i like to obtain (using an sql statement) the list of all user defined indexes and their details specially the column "order by" sort order. e.g. ASC or DESC. Any help would be much appreciated.

Hi,
take a look at: select * from pg_indexes;