psql: Show all query results by default

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.

This is a significantly enhanced version of
3a5130672296ed4e682403a77a9a3ad3d21cef75 (that was later reverted).
There is also much more test coverage for various psql features now.

Author: Fabien COELHO 
Reviewed-by: Peter Eisentraut 
Reviewed-by: "Iwata, Aya"  (earlier version)
Reviewed-by: Daniel Verite  (earlier version)
Reviewed-by: Kyotaro Horiguchi  (earlier version)
Reviewed-by: vignesh C  (earlier version)
Discussion: https://www.postgresql.org/message-id/flat/alpine.DEB.2.21.1904132231510.8961@lancre