how to escape back-slash mark. - Mailing list pgsql-general

From Quan Zongliang
Subject how to escape back-slash mark.
Date
Msg-id 20090415203429.BB57.4125B4E5@gmail.com
Whole thread Raw
Responses Re: how to escape back-slash mark.
List pgsql-general
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 approach to let PostgreSQL conside back-slash as common char?

Regards.

-----------------------------------------------
Quan Zongliang
quanzongliang@gmail.com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn


pgsql-general by date:

Previous
From: Christian Schröder
Date:
Subject: Performance of full outer join in 8.3
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Performance of full outer join in 8.3