Re: [GENERAL] list of index

[Szymon Guz]

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