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

From Tom Lane
Subject Re: proposal - assign result of query to psql variable
Date
Msg-id 12017.1343280977@sss.pgh.pa.us
Whole thread Raw
In response to proposal - assign result of query to psql variable  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal - assign result of query to psql variable
Re: proposal - assign result of query to psql variable
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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: proposal - assign result of query to psql variable
Next
From: Pavel Stehule
Date:
Subject: Re: proposal - assign result of query to psql variable