pgsql: Create a psql command \gset to store query results into psql var

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create a psql command \gset to store query results into psql var
Date: 2013-02-02 22:07:00
Message-ID: E1U1lEi-0006Ib-Aq@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Create a psql command \gset to store query results into psql variables.

This eases manipulation of query results in psql scripts.

Pavel Stehule, reviewed by Piyush Newe, Shigeru Hanada, and Tom Lane

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d2d153fdb08053d655bd0fef14187eed6a674193

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 40 ++++++++++++++
src/bin/psql/command.c | 18 ++++++-
src/bin/psql/common.c | 105 ++++++++++++++++++++++++++++++++---
src/bin/psql/help.c | 5 +-
src/bin/psql/settings.h | 1 +
src/bin/psql/tab-complete.c | 2 +-
src/test/regress/expected/psql.out | 54 ++++++++++++++++++
src/test/regress/parallel_schedule | 2 +-
src/test/regress/serial_schedule | 3 +-
src/test/regress/sql/psql.sql | 39 +++++++++++++
10 files changed, 254 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2013-02-03 05:33:13 pgsql: PL/Python: Add result object str handler
Previous Message Robert Haas 2013-02-02 19:55:10 Re: pgsql: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.