st 2. 11. 2022 v 13:43 odesÃlatel Jehan-Guillaume de Rorthais < j...@dalibo.com> napsal:
> Hi, > > On Fri, 28 Oct 2022 08:52:51 +0200 > Peter Eisentraut <peter.eisentr...@enterprisedb.com> wrote: > > > 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. Regards Pavel
