diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2022-11-15 13:50:27 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2022-11-15 14:27:46 +0100 |
| commit | 5b66de3433e2110b38a2b32aaaa0b9cdac8aacdb (patch) | |
| tree | bc8f7c7f5fb7bd19d70d2ec6561fd7a0fc815768 /src/bin/psql/help.c | |
| parent | a9e9a9f32b35edf129c88e8b929ef223f8511f59 (diff) | |
psql: Add command to use extended query protocol
This adds a new psql command \bind that sets query parameters and
causes the next query to be sent using the extended query protocol.
Example:
SELECT $1, $2 \bind 'foo' 'bar' \g
This may be useful for psql scripting, but one of the main purposes is
also to be able to test various aspects of the extended query protocol
from psql and to write tests more easily.
Reviewed-by: Corey Huinker <corey.huinker@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/e8dd1cd5-0e04-3598-0518-a605159fe314@enterprisedb.com
Diffstat (limited to 'src/bin/psql/help.c')
| -rw-r--r-- | src/bin/psql/help.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/bin/psql/help.c b/src/bin/psql/help.c index f8ce1a07060..b4e0ec2687f 100644 --- a/src/bin/psql/help.c +++ b/src/bin/psql/help.c @@ -189,6 +189,7 @@ slashUsage(unsigned short int pager) initPQExpBuffer(&buf); HELP0("General\n"); + HELP0(" \\bind [PARAM]... set query parameters\n"); HELP0(" \\copyright show PostgreSQL usage and distribution terms\n"); HELP0(" \\crosstabview [COLUMNS] execute query and display result in crosstab\n"); HELP0(" \\errverbose show most recent error message at maximum verbosity\n"); |