Paul Lindner <lindner(at)inuus(dot)com> writes:
> To convert your pre-8.1 database to 8.1 you may have to remove and/or
> fix the offending characters. One simple way to fix the problem is to
> run your pg_dump output through the iconv command like this:
> iconv -c -f UTF8 -t UTF8 -o fixed.sql dump.sql
Is that really a one-size-fits-all solution? Especially with -c?
regards, tom lane