Thread: BUG #1205: psql toggles

BUG #1205: psql toggles

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1205
Logged by:          Doug Bloebaum

Email address:      bloebaum@dma.org

PostgreSQL version: 7.4

Operating system:   SuSE Linux 9.1 (i586)

Description:        psql toggles

Details:

This is a feature request, not a bug:

In psql there is an internal slash command \t (and the equivalent \pset
tuples_only) which toggles a "rows only" result mode.

The problem is that when writing utility SQL scripts to create output, you
can't tell which mode you're toggling to, as the user may have changed
settings within the current session.  The same can be said for all the
"toggle" commands, really.

My request is that at least the \pset versions of the toggle commands take
an "on" or "off" argument, in order to make setting things more discrete.
Something like:

\pset tuples_only off
\pset tuples_only on

Thanks for listening!