Re: list of index

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On
Behalf Of Michael Paquier
Sent: 18 August 2014 02:58
To: farjad(dot)farid(at)checknetworks(dot)com
Cc: Szymon Guz; PostgreSQL
Subject: Re: [GENERAL] list of index

On Fri, Aug 15, 2014 at 11:53 PM,
FarjadFarid(ChkNet)
<farjad(dot)farid(at)checknetworks(dot)com> 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(at)postgresql(dot)org) To make changes to
your subscription:
http://www.postgresql.org/mailpref/pgsql-general