Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > On Thu, Oct 20, 2005 at 03:41:51PM +0530, surabhi.ahuja wrote: >> how can i change the client encoding to LATIN1? > Send the query: > set client_encoding=latin1; Also, whatever client-side library you're using may have alternative ways to specify the same thing. libpq for instance looks for a PGCLIENTENCODING environment variable. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings