Re: bytea and character encoding when inserting escaped

Hi Lee,

> Thanks for the suggestion. I should have mentioned in my original  
> message that as per your suggestion and the suggestion in the  
> do***entation, 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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general