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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
