Alex wrote:
Hi,
I am having a problem with a copy command, saying ERROR: invalid UTF-8
byte sequence detected...
The problem actually is that the entire copy job terminates instead of
just ignoring the record in question.
Is there a way to have faulty records ignored only without terminating
the entire copy job?
Not with COPY - you might want to look for a project called (iirc)
"pgloader" though which might be useful to you.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
