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-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Szymon Guz Sent: 15 August 2014 15:32 To: farjad.fa...@checknetworks.com Cc: PostgreSQL Subject: Re: [GENERAL] list of index 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;
