ERROR: invalid byte sequence for encoding UTF8: 0x00 - Mailing list pgsql-general

From Kiran K V
Subject ERROR: invalid byte sequence for encoding UTF8: 0x00
Date
Msg-id CAGv0ivqrbg6qphPbU-YyKuAb31dVGRWrZC_R8Zdhj3TWbiB=GA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: invalid byte sequence for encoding UTF8: 0x00
List pgsql-general
Hi,

I have a table with bytea column and trying to load the data using copy command.  But Copy command is failing with "ERROR: invalid byte sequence for encoding UTF8: 0x00. Why postgresql is failing to load when data contains 0x00. How to resolve this error ? any workaround to load the data with 0x00 values ?

Please advise. Thank you very much.

Regards,
Kiran

pgsql-general by date:

Previous
From: Paul van der Linden
Date:
Subject: Order of multicolumn gist index
Next
From: jian he
Date:
Subject: Re: postgresql custom variable in pg_settings table