Re: Any way to disable backslash as a string literal escape character? - Mailing list pgsql-general

From Tom Lane
Subject Re: Any way to disable backslash as a string literal escape character?
Date
Msg-id 20279.1072757355@sss.pgh.pa.us
Whole thread Raw
In response to Any way to disable backslash as a string literal escape character?  ("Grant Allen" <Grant.Allen@towersoft.com.au>)
List pgsql-general
"Grant Allen" <Grant.Allen@towersoft.com.au> writes:
> Basically, I want to turn off backslash ( \ ) as an escape character
> in string literals.

No can do without hacking backend code.  But why are you more concerned
about backslash than, say, single-quote (')?  I cannot envision any way
of embedding arbitrary strings into SQL commands that doesn't have some
kind of escape-character rule.

I suspect what you really need is a way to supply strings as out-of-line
parameters to SQL commands.  This is available in PG as of 7.4, and I
think all the other major DBs had it long before.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] Is my MySQL Gaining ?
Next
From: Sean Shanny
Date:
Subject: Re: Out of memory error when doing an update with IN clause