Horton

psql: Show all query results by default

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 3a5130672296ed4e682403a77a9a3ad3d21cef75
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2021-04-06T15:10:24Z
Releases: 14.0 
psql: Show all query results by default

Previously, psql printed only the last result if a command string
returned multiple result sets.  Now it prints all of them.  The
previous behavior can be obtained by setting the psql variable
SHOW_ALL_RESULTS to off.

Author: Fabien COELHO <coelho@cri.ensmp.fr>
Reviewed-by: "Iwata, Aya" <iwata.aya@jp.fujitsu.com>
Reviewed-by: Daniel Verite <daniel@manitou-mail.org>
Reviewed-by: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Reviewed-by: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Reviewed-by: vignesh C <vignesh21@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/alpine.DEB.2.21.1904132231510.8961@lancre

Files

PathChange+/−
contrib/pg_stat_statements/expected/pg_stat_statements.out modified +25 −0
doc/src/sgml/ref/psql-ref.sgml modified +15 −14
src/bin/psql/common.c modified +346 −278
src/bin/psql/help.c modified +2 −0
src/bin/psql/settings.h modified +1 −0
src/bin/psql/startup.c modified +10 −0
src/bin/psql/tab-complete.c modified +1 −1
src/test/regress/expected/copyselect.out modified +12 −2
src/test/regress/expected/psql.out modified +93 −0
src/test/regress/expected/transactions.out modified +57 −1
src/test/regress/sql/copyselect.sql modified +2 −2
src/test/regress/sql/psql.sql modified +38 −0
src/test/regress/sql/transactions.sql modified +1 −1

Documentation touched

Discussion