Re: Upcoming PG re-releases

Paul Lindner <lindner@inuus.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