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

From Pavel Stehule
Subject Re: proposal - assign result of query to psql variable
Date
Msg-id CAFj8pRAjcoXRBNMUFPJ5apjaMD14=yAsiYuLenArpX0tZhnkOA@mail.gmail.com
Whole thread Raw
In response to Re: proposal - assign result of query to psql variable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2012/7/26 Tom Lane <tgl@sss.pgh.pa.us>:
> 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 ...

it could be

Pavel

>
>                         regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal - assign result of query to psql variable
Next
From: David Fetter
Date:
Subject: Re: proposal - assign result of query to psql variable