Re: pgbench - allow to store select results into variables

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>

To: Fabien COELHO <coelho@cri.ensmp.fr>, Tom Lane <tgl@sss.pgh.pa.us>

Cc: Robert Haas <robertmhaas@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Developers <pgsql-hackers@postgresql.org>

Date: 2016-09-02T02:58:03Z

Lists: pgsql-hackers

Hi Fabien,

On 2016/07/16 1:33, Fabien COELHO wrote:
> Here is a v2 with more or less this approach, although \into does not end
> the query, but applies to the current or last sql command. A query is
> still terminated with a ";".

This patch needs to be rebased because of commit 64710452 (on 2016-08-19).

Thanks,
Amit

Commits

pgbench: Remove \cset
- 25ee70511ec2 12.0 landed
pgbench: add \cset and \gset commands
- 6260cc550b0e 12.0 landed
Adjust pgbench to allow non-ASCII characters in variable names.
- 9d36a386608d 11.0 landed
Refactor script execution state machine in pgbench.
- 12788ae49e19 10.0 cited
Allow empty queries in pgbench.
- 6471045230f5 10.0 cited