how to escape back-slash mark.

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to escape back-slash mark.
Date: 2009-04-15 11:42:50
Message-ID: 20090415203429.BB57.4125B4E5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-04-15 11:43:04 Re: Performance of full outer join in 8.3
Previous Message Christian Schröder 2009-04-15 11:03:53 Performance of full outer join in 8.3