diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-02-02 17:06:38 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-02-02 17:06:38 -0500 |
commit | d2d153fdb08053d655bd0fef14187eed6a674193 (patch) | |
tree | d5b988ce6d712fcec154511e90af87b73d34d3e2 /src/bin/psql/help.c | |
parent | 101d6ae755656b675b7c18db655249511982b780 (diff) | |
download | postgresql-d2d153fdb08053d655bd0fef14187eed6a674193.tar.gz postgresql-d2d153fdb08053d655bd0fef14187eed6a674193.zip |
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
Diffstat (limited to 'src/bin/psql/help.c')
-rw-r--r-- | src/bin/psql/help.c | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c index fd7effa87b3..43cb550bd24 100644 --- a/src/bin/psql/help.c +++ b/src/bin/psql/help.c @@ -165,13 +165,14 @@ slashUsage(unsigned short int pager) currdb = PQdb(pset.db); - output = PageOutput(94, pager); + output = PageOutput(95, pager); /* if you add/remove a line here, change the row count above */ fprintf(output, _("General\n")); fprintf(output, _(" \\copyright show PostgreSQL usage and distribution terms\n")); fprintf(output, _(" \\g [FILE] or ; execute query (and send results to file or |pipe)\n")); + fprintf(output, _(" \\gset [PREFIX] execute query and store results in psql variables\n")); fprintf(output, _(" \\h [NAME] help on syntax of SQL commands, * for all commands\n")); fprintf(output, _(" \\q quit psql\n")); fprintf(output, "\n"); @@ -261,7 +262,7 @@ slashUsage(unsigned short int pager) currdb); else fprintf(output, _(" \\c[onnect] [DBNAME|- USER|- HOST|- PORT|-]\n" - " connect to new database (currently no connection)\n")), + " connect to new database (currently no connection)\n")); fprintf(output, _(" \\encoding [ENCODING] show or set client encoding\n")); fprintf(output, _(" \\password [USERNAME] securely change the password for a user\n")); fprintf(output, _(" \\conninfo display information about current connection\n")); |