Re: proposal - assign result of query to psql variable - Mailing list pgsql-hackers

Pavel Stehule <pavel.stehule@gmail.com> writes:
> \eset variable [, variable [..]] query --  it raise exception when
> more than one row is returned or when no row is returned

Better would be a variant on \g, that is you type in the query and
then tell it where to put the result.  We have learned the hard way
that putting SQL commands into the arguments of backslash commands
is a horrid idea.  Maybe
select x,y,... from ...\gset var1 var2 ...
        regards, tom lane