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
