From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Rephrased: Possible to run the server without backslash (C-style) escaping? |
Date: | 2005-02-23 17:53:36 |
Message-ID: | 421CC320.8060508@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | javier wilson | 2005-02-23 18:14:06 | Re: Store procedure -------------- !!!!!!!!!!!!!! URGENTE """"""""""""""" |
Previous Message | Pavel Stehule | 2005-02-23 17:06:22 | Re: Help with a very newbie question... |