Thanks for the tip Michael. I am still a newbie to postgresql. Have to set aside more time to get to acquiented with its engine's features. Haven't used psql in any meaningful way and yet to go through a proper development cycle debugging functions etc. Are there any tutorials for features of psql? and debug session ? Many thanks. Farjad -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Michael Paquier Sent: 18 August 2014 02:58 To: farjad.farid@xxxxxxxxxxxxxxxxx Cc: Szymon Guz; PostgreSQL Subject: Re: list of index On Fri, Aug 15, 2014 at 11:53 PM, FarjadFarid(ChkNet) <farjad.farid@xxxxxxxxxxxxxxxxx> wrote: > 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? FWIW, I always find good source of inspiration the queries used by psql to fetch information from system views. You can get a look at them with psql -E. Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
