Create a psql command \gset to store query results into psql variables.
Tom Lane <tgl@sss.pgh.pa.us>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/psql-ref.sgml | modified | +40 −0 |
| src/bin/psql/command.c | modified | +17 −1 |
| src/bin/psql/common.c | modified | +96 −9 |
| src/bin/psql/help.c | modified | +3 −2 |
| src/bin/psql/settings.h | modified | +1 −0 |
| src/bin/psql/tab-complete.c | modified | +1 −1 |
| src/test/regress/expected/psql.out | added | +54 −0 |
| src/test/regress/parallel_schedule | modified | +1 −1 |
| src/test/regress/serial_schedule | modified | +2 −1 |
| src/test/regress/sql/psql.sql | added | +39 −0 |