On Mon, Aug 18, 2014 at 1:40 PM, FarjadFarid(ChkNet)
wrote:
> Are there any tutorials for features of psql?
I don't recall particularly one, but the documentation is worth
reading and well-maintained. Here for psql:
http://www.postgresql.org/docs/devel/static/app-psql.html
> and debug session ?
ubject: Re: [GENERAL] list of index
On Fri, Aug 15, 2014 at 11:53 PM,
FarjadFarid(ChkNet)
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 sour
On Fri, Aug 15, 2014 at 11:53 PM, FarjadFarid(ChkNet)
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 inf
Thanks Melvin, That worked for me. Great.
From: Melvin Davidson
[mailto:melvin6...@yahoo.com]
Sent: 15 August 2014 15:46
To: farjad.fa...@checknetworks.com;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] list of index
>On a Postgresql database i like to obtain (using
res.
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
On 15 August 2014 16:23, FarjadFarid(ChkNet) 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 ,
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.
