On Thursday, July 5, 2018, Alexey Bashtanov <bashtanov(at)imap(dot)cc> wrote:
> Hi Brice,
>
> On 03/07/18 05:28, Brice André wrote:
>
>> insert into test (test) values (E'\xC744'::bytea);
>>
>
> I think double backslash needs to be used.
> See https://www.postgresql.org/docs/current/static/datatype-bina
> ry.html#id-1.5.7.12.9
>
Or lose the "E" marker to turn the escape string literal into an ordinary
string literal.
David J.