Rephrased: Possible to run the server without backslash (C-style) escaping?

Поиск
Список
Период
Сортировка
Искать
От
Ken Johanson
Тема
Rephrased: Possible to run the server without backslash (C-style) escaping?
Дата
Msg-id
421CC320.8060508@kensystem.com
Ответ на
Список
Дерево обсуждения
Possible to run the server with ANSI/ISO string escapeing instead of C-style escapes? Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string escapeing Bruce Momjian <pgman@candle.pha.pa.us>
Re: Possible to run the server with ANSI/ISO string escapeing Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string escapeing Bruce Momjian <pgman@candle.pha.pa.us>
Re: Possible to run the server with ANSI/ISO string escapeing Tom Lane <tgl@sss.pgh.pa.us>
Re: Possible to run the server with ANSI/ISO string escapeing Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string Jeff Davis <jdavis-pgsql@empires.org>
Re: Possible to run the server with ANSI/ISO string Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string Jeff Davis <jdavis-pgsql@empires.org>
Re: Possible to run the server with ANSI/ISO string Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string Bruno Wolff III <bruno@wolff.to>
Re: Possible to run the server with ANSI/ISO string Ken Johanson <pg-user@kensystem.com>
Re: Possible to run the server with ANSI/ISO string escapeing Martijn van Oosterhout <kleptog@svana.org>
Re: Possible to run the server with ANSI/ISO string escapeing Peter Eisentraut <peter_e@gmx.net>
Re: Possible to run the server with ANSI/ISO string escapeing Ken Johanson <pg-user@kensystem.com>
Rephrased: Possible to run the server without backslash (C-style) escaping? Ken Johanson <pg-user@kensystem.com>
More specifically, I'd like to disable the non-standard backslash
escaping behavior of the server, so that backslashes aren't discarded, like:

insert into table values ('This won''t work when inserting a \
character'); -> 'This won't work when inserting a  character'

Instead I'd like for only single quotes (apostrophes) to server as the
escape character (for themselves), as in the iso/ansi recommendations
-so that the server behaves the same as Oracle, ms, and most other
databases in this regard.

I am living testament to all the users who switched from the 'big'
databases to pg and had the unpleasant surprise of having lost all the
backslashes chars -as well as having to tweak apps to get them to work.

If nothing else, a VERY prominently placed warning on the docs front
page should warn new users of the nonstandard behavior, imo. This can be
a life saver.

ken





В списке pgsql-general по дате отправления
От: Pavel Stehule
Дата:
От: javier wilson
Дата:
FAQ