[ADMIN] convert from latin1 to utf8

2013-10-10 Thread Marc Fromm
I need to convert a bunch of my databases to utf8 before I can migrate them to postgresql 8.4. Is there a command that during the pg_dumpall process the encoding can be changed from latin1 to utf8? This is the error I get when migrating the databases from 8.1 to a machine running 8.4

Re: [ADMIN] convert from latin1 to utf8

2013-10-10 Thread Scott Whitney
) To: pgsql-admin@postgresql.org Subject: [ADMIN] convert from latin1 to utf8 I need to convert a bunch of my databases to utf8 before I can migrate them to postgresql 8.4. Is there a command that during the pg_dumpall process the encoding can be changed from latin1 to utf8?   This is the error I