You can do this by converting the characters in raw dump file directly. iconv -f 8859_1 -t UTF-8 backup.db.psql > backup.db.psql.utf8
Then convert the line in backup.db.psql.utf8 from: SET client_encoding = 'SQL_ASCII'; to: SET client_encoding = 'UTF8'; -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-restore-a-SQL-ASCII-encoded-database-to-a-new-UTF-8-db-tp1918020p4884598.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
