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 ?
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
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
On 08/17/2014 03:32 PM, Redoute wrote:
Am 17.08.2014 17:17, schrieb Tom Lane:
Me too, but I repeat the point that what you have to twiddle is the
postmaster's environment; in particular you have to set LC_CTYPE
(or maybe better LC_ALL), which cannot be set from the config file.
With "set LC_C
Am 17.08.2014 17:17, schrieb Tom Lane:
> Me too, but I repeat the point that what you have to twiddle is the
> postmaster's environment; in particular you have to set LC_CTYPE
> (or maybe better LC_ALL), which cannot be set from the config file.
With "set LC_CTYPE" do you mean to create an simple
Am 17.08.2014 16:49, schrieb Adrian Klaver:
> Here is a blog
> that seems to address your issue somewhat:
>
> http://www.g-loaded.eu/2011/02/27/locale-windows/
This seems somewhat confused. But it made me playing with initdb, which
I did not try before.
I got:
> >initdb.exe --locale=american_u
Adrian Klaver writes:
> On 08/17/2014 03:30 AM, Redoute wrote:
>> Am 16.08.2014 21:40, schrieb Tom Lane:
>>> You need to make sure the postmaster's
>>> environment selects a UTF8 locale.
>> So is this possible at all in Windows?
> I am afraid Windows locale setting is a mystery to me.
Me too, b
On 08/17/2014 03:30 AM, Redoute wrote:
Am 16.08.2014 21:40, schrieb Tom Lane:
You need to make sure the postmaster's
environment selects a UTF8 locale.
So is this possible at all in Windows?
http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx
According to this table Locales support ANSI an
Am 16.08.2014 21:40, schrieb Tom Lane:
> You need to make sure the postmaster's
> environment selects a UTF8 locale.
So is this possible at all in Windows?
http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx
According to this table Locales support ANSI and OEM codepages, but
there is no mentio