I have used pg_dumpall on a database that was created with LATIN1
encoding and has a whole bunch of messy latin1 data in it.
I want to restore this data to a new db with UTF-8 encoding, with the
data converted so the 8859-1 characters display properly.
How should I go about doing this?