Re: bytea char escaping

Stephen Robert Norris wrote:
> On Tue, 2003-06-24 at 22:42, Ivar wrote:
>>What chars must be escaped in string and how exactly?
>From memory, you have to escape \ -> \\, ' -> \' and I think NULL to
> \\000. I have a feeling that you need to escape all the non-printable
> characters to \xxx escape codes, but I may be wrong there.
>
> I've just looked at my code to do all this, and I'm ashamed to say I
> can't really work out what it escapes. Must document better.

See:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=datatype-binary.html

HTH,

Joe