psql: Add command to use extended query protocol
authorPeter Eisentraut <peter@eisentraut.org>
Tue, 15 Nov 2022 12:50:27 +0000 (13:50 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Tue, 15 Nov 2022 13:27:46 +0000 (14:27 +0100)
commit5b66de3433e2110b38a2b32aaaa0b9cdac8aacdb
treebc8f7c7f5fb7bd19d70d2ec6561fd7a0fc815768
parenta9e9a9f32b35edf129c88e8b929ef223f8511f59
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
doc/src/sgml/ref/psql-ref.sgml
src/bin/psql/command.c
src/bin/psql/common.c
src/bin/psql/help.c
src/bin/psql/settings.h
src/bin/psql/tab-complete.c
src/test/regress/expected/psql.out
src/test/regress/sql/psql.sql