Re: Invalid byte sequence

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Yambu <hyambu(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Invalid byte sequence
Date: 2021-07-01 07:37:26
Message-ID: 8a70f9f6d154644f6c7f000e661a7f0779cba774.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2021-07-01 07:38:38 Re: Invalid byte sequence
Previous Message Yambu 2021-07-01 07:29:58 Invalid byte sequence