Re: default client_encoding with psql on windows

From: John DeSoi <desoi(at)pgedit(dot)com>
To: thomas(at)microdop(dot)org
Cc: Postgresql-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: default client_encoding with psql on windows
Date: 2006-05-10 12:06:22
Message-ID: 648095AF-8613-4069-B72A-38259AA0842C@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Don't forget to CC the list so everyone can see your reply]

The pgInstaller uses Wix which is open source. You can download it
from Source Forge.

John

On May 10, 2006, at 7:23 AM, Thomas Sondag wrote:

> 2006/5/10, John DeSoi <desoi(at)pgedit(dot)com>:
>>
>> On May 8, 2006, at 12:14 PM, Thomas Sondag wrote:
>>
>> > I tried various things with the --set option of psql without
>> > success, like
>> > --set client_encoding=win1252 or --set CLIENT_ENCODING=win1252
>> or --
>> > set encoding=win1252.
>>
>>
>> The variables are case sensitive, so it looks like you left out the
>> right one. The docs say the psql variable is ENCODING (all caps).
>
> --set ENCODING=win1252 doesn't work
>>
>> If that does not work maybe you could call \encoding in the psqlrc
>> file?
>
> \encoding win1252 in psqlrc.conf do the work, thanks for the clue.
> But it may have some side effect with psql.exe in a shell script (like
> importing data in UTF8).
>
> Today I find one environement variable in the pg_dump man page :
> PGCLIENTENCODING
>
> This shortcut solve most of my problems :
> C:\WINDOWS\system32\cmd.exe /k chcp 1252 && set PGPORT=5432 && set
> PGCLIENTENCODING=win1252 &&"C:\Program
> Files\PostgreSQL\8.1\bin\psql.exe" -h localhost -p 5432 postgres
> "postgres"
>
> I think this shorcut could solve a lot of isue, with PostgreSQL on
> Windows.
>
> I would like to modify the PostgreSQL msi myself to replace the
> default psql link with that one, but I don't have the tool to do it.
>
> I will post a bug report for Pginstaller.
>
> Thanks
>
> Thomas

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2006-05-10 12:15:22 Re: Arguments Pro/Contra Software Raid
Previous Message Teodor Sigaev 2006-05-10 12:01:18 Re: [GENERAL] intarray internals