Robert Haas <robertmhaas@gmail.com> writes:
> I think maybe what we need here is a piece of syntax to indicate that a
> specific parameter should be substituted after first being passed
> through PQescapeStringConn.
I agree that a global flag that changes the behavior of :foo is a
seriously bad idea. Alternate syntax would be much better, but how
exactly can we shoehorn that in? Maybe something like:!foo
ie put some non-letter flags between the : and the variable name.
It would obviously not work to use ::foo, but I think many other
punctuation characters would be safe (would not conflict with any
likely SQL usage). We could have a couple of different flags to
signal whether you want single or double quoting of the variable
value.
regards, tom lane