Re: [GENERAL] list of index

2014-08-17 Thread Michael Paquier
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 ?

Re: [GENERAL] list of index

2014-08-17 Thread FarjadFarid(ChkNet)
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

Re: [GENERAL] list of index

2014-08-17 Thread Michael Paquier
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Adrian Klaver
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Redoute
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Redoute
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Tom Lane
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Adrian Klaver
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

Re: [GENERAL] logfile character encoding

2014-08-17 Thread Redoute
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