Converting a Postgres Database to UTF8
February 27, 2011
I have a database that is struggling to store some of the data my users are entering. It's a default postgres database, which means it's in LATIN1 not UTF8. This post covers converting a database from LATIN1 to UTF8.
Dump Database
Use pg_dump to get the data from the database …