Thanks Laurenz, any suggestions on what tool I can use to clean the data?
On Thu, Jul 1, 2021 at 9:37 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
On Thu, 2021-07-01 at 09:29 +0200, Yambu wrote:
> ERROR: invalid byte sequence for encoding "UTF8": 0x00
> CONTEXT: COPY table1, line 377617
That means that there is an ASCII 0 byte in a string somewhere in the file.
This character is not allowed in strings in PostgreSQL.
You will have to fix the data before you can load them into PostgreSQL.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
