Allow \pset to parse "on or off" for boolean values - Mailing list pgsql-patches

From Chad Wagner
Subject Allow \pset to parse "on or off" for boolean values
Date
Msg-id 81961ff50702181000o2b15aed9g4098580a33ee73e9@mail.gmail.com
Whole thread Raw
Responses Re: Allow \pset to parse "on or off" for boolean values
Re: Allow \pset to parse "on or off" for boolean values
List pgsql-patches
This is a TODO item:

        o Allow psql \pset boolean variables to set to fixed values, rather
          than toggle


Basically allows for:
test=# \pset expanded on
Expanded display is on.
test=# \pset footer off
Default footer is off.
test=# \pset footer
Default footer is on.
test=# \pset footer
Default footer is off.
test=# \pset footer
Default footer is on.


Basically the change is to check if value in do_pset is != NULL to call ParseVariableBool to get a true/false and set the value directly, of the second parameter is not provided then the "old logic" of toggling is supported.

The pset variables that are adjusted are:
expanded
numericlocale
tuples_only
pager (supports on/off/always now)
footer

Attachment

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: further bootstrap cleanup
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: patch for contrib/xml2