Allow \pset to parse "on or off" for boolean values

From: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Allow \pset to parse "on or off" for boolean values
Date: 2007-02-18 18:00:58
Message-ID: 81961ff50702181000o2b15aed9g4098580a33ee73e9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
psql_pset_parsebool.diff application/octet-stream 8.8 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Nikolay Samokhvalov 2007-02-18 18:57:56 Re: patch for contrib/xml2
Previous Message Andrew Dunstan 2007-02-18 18:00:43 Re: further bootstrap cleanup