Re: proposal - assign result of query to psql variable

On 01/26/2013 11:42 AM, Tom Lane wrote:

> A probably-useful extension to this basic concept is to allow \gset
> to specify an optional prefix, that is
>     select 1 as x, 2 as y \gset p_
> would set p_x and p_y.  This would make it easier to manage results from
> multiple \gset operations, and to be sure that you didn't accidentally
> overwrite some built-in variable.

+1. This looks quite nifty. Maybe useful too to have a default prefix 
via some setting.


cheers

andrew