-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I haven't found a way to set the client encoding of a psql connection other then "\encoding" which is arkward for batch processing. As .psqlrc is being ignored during batch processing and the internal encoding is being set *after* "-v", I have to resort to arkward solutions in order to read data via scripts. (To whom it may concern: instead of using "-c" you can pipe your command from stdin). Shouldn't psql honour the current locale setting (LC_CTYPE) or/and have a command line option to set the encoding? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists <at> klawitter <dot> de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBmGry1Xdt0HKSwgYRAgBYAJ4yxnCSDn3MgTvuLUs8t/bffC7HDwCeMDr2 j8np4ISSUI5AvjQE30AfvCM= =4f1P -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match