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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
