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;