ERROR: invalid byte sequence for encoding UTF8: 0x00

[Kiran K V <kirankv.1982@xxxxxxxxx>]

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