Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3697: utf8 issue: can not reimport a table that was successfully exported. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3697: utf8 issue: can not reimport a table that was successfully exported.
Date
Msg-id 17741.1193330341@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3697: utf8 issue: can not reimport a table that was successfully exported.  ("Marc Mamin" <m.mamin@intershop.de>)
List pgsql-bugs
Tree view 
"Marc Mamin" <M.Mamin@intershop.de> writes:
> Is there a recommendation how to clean these data (I know where to
> search for them)

Usually people do it by running iconv with the delete-bad-data option
on a pg_dump file.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Yet another problem with ILIKE and UTF-8
Next
From: "Pierre-Yves Strub"
Date:
Subject: Re: BUG #3696: FK integrity check bypassed using rules.