Pavel Stehule <pavel.stehule@gmail.com> 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 good if we can use both old and new behaviors at once
instead of \pexec switch. Something like:
SELECT * FROM :tablename WHERE id = $value
BTW, this proposal is a partial solution for scripting in psql.
But we will want other goodies soon - assignment, if, loop...
If there is a total solution, it would be better than a partial one.
I've heard pgAdmin uses pgScript as a client-side language.
Should we also take the language (or client-side plpgsql) in psql?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center