Horton

psql: Rename meta-command \close to \close_prepared

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: fc39b286ad7262a4aac8ff9a34f244763bed7a53
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-06-24T04:12:46Z
Releases: 18.0 
psql: Rename meta-command \close to \close_prepared

\close has been introduced in d55322b0da60 to be able to close a
prepared statement using the extended protocol in psql.  Per discussion,
the name "close" is ambiguous.  At the SQL level, CLOSE is used to close
a cursor.  At protocol level, the close message can be used to either
close a statement or a portal.

This patch renames \close to \close_prepared to avoid any ambiguity and
make it clear that this is used to close a prepared statement.  This new
name has been chosen based on the feedback from the author and the
reviewers.

Author: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: Jelte Fennema-Nio <postgres@jeltef.nl>
Discussion: https://postgr.es/m/3e694442-0df5-4f92-a08f-c5d4c4346b85@eisentraut.org

Files

PathChange+/−
doc/src/sgml/ref/psql-ref.sgml modified +4 −4
doc/src/sgml/release-18.sgml modified +1 −1
src/bin/psql/command.c modified +6 −6
src/bin/psql/common.c modified +1 −1
src/bin/psql/help.c modified +2 −1
src/bin/psql/tab-complete.in.c modified +1 −1
src/test/regress/expected/psql.out modified +7 −7
src/test/regress/expected/psql_pipeline.out modified +3 −3
src/test/regress/sql/psql_pipeline.sql modified +3 −3
src/test/regress/sql/psql.sql modified +6 −6

Documentation touched

Discussion