Postgres Pro
Downloads
Home   >   mailing lists

Re: list of index - Mailing list pgsql-general

From Szymon Guz
Subject Re: list of index
Date
Msg-id CAFjNrYt9eTx355YDN9LFUg=rcmFLLD1if_KTHX0Eep-uefNLxA@mail.gmail.com
Whole thread Raw
In response to list of index  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
Responses Re: list of index  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
List pgsql-general
Tree view
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: "FarjadFarid\(ChkNet\)"
Date:
Subject: list of index
Next
From: "FarjadFarid\(ChkNet\)"
Date:
Subject: Re: list of index