Re: [GENERAL] how to escape back-slash mark.

2009-04-15 Thread Quan Zongliang
> I think you're looking for the "standard_conforming_strings" parameter. Yes, it is. Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how to escape back-slash mark.

2009-04-15 Thread Tom Lane
Quan Zongliang writes: > Has a approach to let PostgreSQL conside back-slash as common char? I think you're looking for the "standard_conforming_strings" parameter. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

[GENERAL] how to escape back-slash mark.

2009-04-15 Thread Quan Zongliang
hi, all The PostgreSQL has a option: backslash_quote. It can be on, off or safe_encoding. How to set it to ingore back-slash check? The command: INSERT INTO table_name VALUES(..., '\\', ...); always get a warning message whatever it is. If use E'\\', value will be saved as '\' in database. Has a