Re: psql: add \pset true/false

Matthijs van der Vleuten <matthijs@zr40.nl>

From: Matthijs van der Vleuten <matthijs@zr40.nl>
To: Brendan Jurd <direvus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Marko Tiikkaja <marko@joh.to>, Daniel Verite <daniel@manitou-mail.org>, PostgreSQL hackers <pgsql-hackers@postgresql.org>
Date: 2015-11-12T16:41:49Z
Lists: pgsql-hackers
> On 12 Nov 2015, at 14:21, Brendan Jurd <direvus@gmail.com> wrote:
> 
> On Fri, 30 Oct 2015 at 00:51 Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>> wrote:
> The really key argument that hasn't been addressed here is why does such
> a behavior belong in psql, rather than elsewhere?  Surely legibility
> problems aren't unique to psql users.  Moreover, there are exactly
> parallel facilities for other datatypes on the server side: think
> DateStyle or bytea_output.  So if you were trying to follow precedent
> rather than invent a kluge, you'd have submitted a patch to create a GUC
> that changes the output of boolout().
> 
> I find Tom's analogy to datestyle and bytea_output convincing.
> 
> +1 for a GUC that changes the behaviour of boolout. 

-1 for changing boolout(). It will break anything that receives boolean values from the server. How a client is going to display values (of any type) is logic that should belong in the client, not in the protocol.

Commits

  1. Add \pset options for boolean value display