-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Sam, Thanks for your answer! :) The matter of fact is that the script itself is the connected client where the postgresql server is concerned. It then connects to another server (the M$SQL one) and, on a row basis, inserts data coming from the aforementioned connection... So, to all effects, the script is *the* client... :) Best regards, Pedro Doria Meunier On 10/09/2009 02:38 PM, Sam Mason wrote: > On Fri, Oct 09, 2009 at 11:39:47AM +0100, Pedro Doria Meunier > wrote: >> I cannot simply use "Set Client Encoding to LATIN1" as the >> "client" itself is the script ... :) > > What does this mean? surely if it's just a "script" you can put > another line at the beginning of the script that says this? > > If you really can't do this, how about using ALTER USER to change > the the user that they use latin1 by default? > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAkrPTYQACgkQ2FH5GXCfxAvzSQCfV1tdIq3NSQVN0O8gNfQS1Iok wxMAoIyGe2pQeWz4k3HSaeIEOaT4r49G =/gqA -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general