Re: bytea and character encoding when inserting escaped literals - Mailing list pgsql-general

Hi Lee,

> Thanks for the suggestion. I should have mentioned in my original
> message that as per your suggestion and the suggestion in the
> documentation, I have tried escaping the backslashes. When I do
> this, I get the error:
>
>  ERROR: invalid input syntax for type bytea
>
> I tried also doing
>
>  INSERT INTO myTable VALUES (..., E'\\x15\\x1C\\x2F\\x00\
> \x02...'::bytea, ...) ;
>
> but get the same errors.

I think i see another problem with your query. You should convert to
three-digit octal (something like \\001\\002...) not \\x01 (hex?).

Jan