Postgres Pro
Downloads
Home   >   mailing lists

Re: list of index - Mailing list pgsql-general

From FarjadFarid\(ChkNet\)
Subject Re: list of index
Date
Msg-id 002901cfb898$ba3c2f80$2eb48e80$@checknetworks.com
Whole thread Raw
In response to Re: list of index  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: list of index  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view

 

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?!!

 

Any suggestion would be very welcome.  Many Thanks.

 

 

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

 

On 15 August 2014 16:23, FarjadFarid(ChkNet) <farjad.farid@checknetworks.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;

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: list of index
Next
From: "FarjadFarid\(ChkNet\)"
Date:
Subject: Re: list of index