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

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