Re: [HACKERS] proposal: using PQexecParams in psql (using variables as real params)

2009-11-16 Thread Pavel Stehule
2009/11/16 Itagaki Takahiro : > > Pavel Stehule wrote: > >> I propose to add possibility to use psql variables as real query >> parameters. The goal of this proposal is simplification of creating >> psql based commands. > >> postgres=# \pexec >> Separately passing parameters is on. >> postgres=# s

Re: [HACKERS] proposal: using PQexecParams in psql (using variables as real params)

2009-11-15 Thread Itagaki Takahiro
Pavel Stehule wrote: > I propose to add possibility to use psql variables as real query > parameters. The goal of this proposal is simplification of creating > psql based commands. > postgres=# \pexec > Separately passing parameters is on. > postgres=# select upper(:message); There might be go

[HACKERS] proposal: using PQexecParams in psql (using variables as real params)

2009-11-15 Thread Pavel Stehule
Hello I propose to add possibility to use psql variables as real query parameters. The goal of this proposal is simplification of creating psql based commands. Current using of psql variables based on substitution has large area of using, but has some risks. a) there are possible sql injection, b)