Hi Neil,
On May 15, 2007, at 5:51 PM, Neil Saunders wrote:
> Any idea why the --encoding flag didn't do this via pg_dump?
I'm not really sure. I supposed for one thing it might be difficult
to do the right thing going from SQL_ASCII to UTF8.
I had some issues with 8.0 -> 8.1 that I was able to fix with
something like this before dumping it:
update my_table set comments = translate(comments, chr(169), 'c')
where comments like '%' || chr(169) || '%';
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL