Horton
Menu

Re: proposal - assign result of query to psql variable

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-07-26T05:36:17Z
Lists: 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix oversight in new code for printing rangetable aliases.