I'm at 8.2.3
I do a data only pg_dump. I drop the database, then recreate it with
the correct encoding. Then load the data back in with psql.
Carol
On Jul 15, 2008, at 11:04 AM, Peter Eisentraut wrote:
> Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
>> I have some databases that use SQL ASCII or Latin1 encoding that need
>> to be UTF8. When I have drop the database and recreated it with the
>> correct encoding I get errors in restoring the data. How is this
>> done?
>
> What is your PostgreSQL version? What is the exact command sequence?
>
> The sort of problem you describe is usually fixed by setting the
> client
> encoding correctly, but recent versions should do this
> automatically for
> dumps/restores.