Re: info about patch: using parametrised query in psql

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