Tom Lane wrote:
> In any case I don't think that "getting stuff from
> psql variables into a DO script" is the way to define the problem.
> It's "getting stuff from shell variables into a DO script" that is the
> real-world problem.
Indeed. But setting psql variables from the command line is easy. We
have a nifty switch for it. So we could reduce one problem to the other.
> Maybe psql is the wrong tool altogether.
>
>
>
Yeah. The workaround is to use some sort of wrapper, in shell script,
perl or whatever. Maybe we should just let sleeping dogs lie.
I think you and I are in agreement though that an SQL level mechanism is
not the way to go, at least for now.
cheers
andrew