[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #7505: Backslash escaping not necessary
From:       Thomas Kellerer <spam_eater () gmx ! net>
Date:       2012-08-26 7:04:45
Message-ID: k1chqc$2cp$1 () ger ! gmane ! org
[Download RAW message or body]

ovadyaj@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:      ovadyaj@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


[prev in list] [next in list] [prev in thread] [next in thread]