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