> This adds a new psql command \gp that works like \g (or semicolon) but > uses the extended query protocol. Parameters can also be passed, like > > SELECT $1, $2 \gp 'foo' 'bar'
As I wrote in my TCE review, would it be possible to use psql vars to set some named parameters for the prepared query? This would looks like:
\set p1 foo \set p2 bar SELECT :'p1', :'p2' \gp
This seems useful when running psql script passing it some variables using -v arg. It helps with var position, changing some between exec, repeating them in the query, etc.
Thoughts?
I don't think it is possible. The variable evaluation is done before parsing the backslash command.
