Re: Help with COPY Error: invalid UTF-8 byte .... - Mailing list pgsql-general

From Richard Huxton
Subject Re: Help with COPY Error: invalid UTF-8 byte ....
Date
Msg-id 438B16CA.3060806@archonet.com
Whole thread Raw
In response to Help with COPY Error: invalid UTF-8 byte ....  (Alex <alex@meerkatsoft.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Errors with temporary tables
Next
From: Haim Ashkenazi
Date:
Subject: Re: need help in designing a database.