On Mon, 15 Sep 2003, Barry Lind wrote:
> Malcolm,
>
> Without knowing what errors you are seeing, I can't say for sure what is
> going wrong for you. However the following seems to work for me:
>
> pg_dump -f test.dmp testdb
> createdb -E unicode newtestdb
> psql -f test.dmp newtestdb
If you have non-unicode characters in the ascii database the restore to a
unicode database will fail. People have recommended running iconv on the
dump file to convert it to unicode, for me setting
PGCLIENTENCODING=UNICODE before the dump of the original database fixed
the problem with bad characters.
Kris Jurka