On 04/12/12 11:09 PM, Zhidong She wrote:
but in 9.1.3, the postgresql denied the same sql, then it worked after
I changed it to
insert into test values('abc''a');
How to configure 9.1.3 and let it also accept \ as the escpage? Could
someone help me out?
use E'abc\'a', this is the SQL standard for escaped strings.
or even better, use $$ quoting, like $$abc'a$$
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
