Re: list of index

[Szymon Guz <mabewlun@xxxxxxxxx>]

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