From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Fabien COELHO <coelho@cri.ensmp.fr>,
        Pavel Stehule <pavel.stehule@gmail.com>,
        PostgreSQL Developers <pgsql-hackers@postgresql.org>
Subject: Re: pgbench - allow to store select results into variables
In-reply-to: 
 <CA+TgmoZDCapESp0Gdn3r5GJm3GjuS0A3Vhvfh7aamW9xieom6w@mail.gmail.com>
References: <alpine.DEB.2.20.1607091005330.3412@sto>
 <CAFj8pRAgU0OzGM7Vqpf2KUR0KP2YNhtG54ji06W5StGmwyQKnA@mail.gmail.com>
 <alpine.DEB.2.20.1607091057300.3412@sto>
 <CAFj8pRBGrdiroRyJgCjtOmOrHCQu0L8KDGLU5czD2q+jF8bUxQ@mail.gmail.com>
 <alpine.DEB.2.20.1607091441480.3412@sto>
 <CA+TgmoaFOUVh5E5qbMjV6L6ub1NFML7U+4Cx+8CvLQgRPrO4Ng@mail.gmail.com>
 <32184.1468440143@sss.pgh.pa.us>
 <CA+TgmoZDCapESp0Gdn3r5GJm3GjuS0A3Vhvfh7aamW9xieom6w@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Wed, 13 Jul 2016 15:07:16 -0500"
Date: Wed, 13 Jul 2016 16:13:43 -0400
Message-ID: <32591.1468440823@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Jul 13, 2016 at 3:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I note also that we were talking a couple months ago
>> about trying to align psql and pgbench backslash commands more closely.
>> This would not be a good step in that direction.

> True, but I'd still argue that \into is a lot more readable than
> \gset.  Maybe both programs should support both commands.

Meh, personal preference there no doubt.  I'd be okay with both programs
supporting both commands, but the \into command as described here would
be quite unreasonable to implement in psql.  It needs to act more like
a semicolon-substitute, as \g and the rest of its family do.  (I think
I'd also lobby for spelling it \ginto.)

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers