#!/bin/sh
dropdb testx
createdb -E UNICODE testx

psql testx <<EOS
\encoding latin1
create table t ( a text, b text );
insert into t values ( 'Aßlach', 'test' );
update t set b = lower(a);
\q
EOS

pg_dump -t t testx >DUMP
dropdb testx
createdb -E UNICODE testx
psql -f DUMP testx