Re: list of index - Mailing list pgsql-general

From FarjadFarid\(ChkNet\)
Subject Re: list of index
Date
Msg-id 000901cfba9e$840b0eb0$8c212c10$@checknetworks.com
Whole thread Raw
In response to Re: list of index  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: list of index  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On
Behalf Of Michael Paquier
Sent: 18 August 2014 02:58
To: farjad.farid@checknetworks.com
Cc: Szymon Guz; PostgreSQL
Subject: Re: [GENERAL] list of index

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



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: list of index
Next
From: Michael Paquier
Date:
Subject: Re: list of index