Horton

Re: Determining client_encoding from client locale

Peter Geoghegan <peter.geoghegan86@gmail.com>

View thread
From: Peter Geoghegan <peter.geoghegan86@gmail.com>
To: Susanne Ebrecht <susanne@2ndquadrant.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Jaime Casanova <jcasanov@systemguards.com.ec>, Magnus Hagander <magnus@hagander.net>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Date: 2011-01-17T13:26:33Z
Lists: pgsql-hackers 
On 17 January 2011 12:58, Susanne Ebrecht <susanne@2ndquadrant.com> wrote:
> Hello,
>
> maybe i missed pre-discussion but ...
>
> I miss considering auto-detect of file encoding.
>
> A simple example:
> $ psql -f dump.sql db
>
> What happens when dump.sql is written by using
> another encoding?

That doesn't tend to be much of a problem in practice because pg_dump
will have the dump SET client_encoding as appropriate from the DB
encoding.

-- 
Regards,
Peter Geoghegan