Re: bytea char escaping - Mailing list pgsql-general

From Stephen Robert Norris
Subject Re: bytea char escaping
Date
Msg-id 1056505653.24406.5.camel@ws12.commsecure.com.au
Whole thread Raw
In response to bytea char escaping  ("Ivar" <ivar@lumisoft.ee>)
Responses Re: bytea char escaping  (Joe Conway <mail@joeconway.com>)
List pgsql-general
On Tue, 2003-06-24 at 22:42, Ivar wrote:
> Hi,
>
> What chars must be escaped in string and how exactly?
>
> LF -> \\n
> CR -> \\r

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.

    Stephen
--
Stephen Robert Norris <srn@commsecure.com.au>
CommSecure Australia Pty Ltd


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PlPython
Next
From: Joe Conway
Date:
Subject: Re: bytea char escaping