ovad...@gmail.com wrote on 24.08.2012 21:59:
The following bug has been logged on the website:
Bug reference: 7505
Logged by: Jeff Ovadya
Email address: ovad...@gmail.com
PostgreSQL version: 9.1.4
Operating system: PostgreSQL 9.1.4, compiled by Visual C++ build 150
Description:
Also noticed similar issue escaping single quotes: Backslash will not work
to escape, but doubling up the quotes works.
Which is the correct behaviour and conforms to the SQL standard (and nearly all
other DBMS behave the same way)
But if you want to use the backslash to escape single quotes check out the
parameter
"standard_conforming_strings" which controls this behaviour:
http://www.postgresql.org/docs/9.1/static/runtime-config-compatible.html#GUC-STANDARD-CONFORMING-STRINGS
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
