Re: bytea char escaping

Поиск
Список
Период
Сортировка
От Stephen Robert Norris
Тема Re: bytea char escaping
Дата
Msg-id 1056505653.24406.5.camel@ws12.commsecure.com.au
обсуждение исходный текст
Ответ на bytea char escaping  ("Ivar" <ivar@lumisoft.ee>)
Ответы Re: bytea char escaping  (Joe Conway <mail@joeconway.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PlPython
Следующее
От: Joe Conway
Дата:
Сообщение: Re: bytea char escaping