Re: psql: add \pset true/false - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: psql: add \pset true/false
Date
Msg-id CADxJZo1FDyEqwFcF21crkxKbvCkkmHHiRjbJiGphTB=7tGnQpQ@mail.gmail.com
Whole thread Raw
In response to Re: psql: add \pset true/false  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql: add \pset true/false  (Matthijs van der Vleuten <matthijs@zr40.nl>)
List pgsql-hackers
On Fri, 30 Oct 2015 at 00:51 Tom Lane <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.

And also +1 for doing anything at all to improve on the t/f output.  Those glyphs are way too similar to each other.

I think U+2713 and U+2717 (✓ and ✗) are the obvious choices for a boolean, but if we have a GUC we can set this to taste.

Cheers,
BJ

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: CustomScan support on readfuncs.c
Next
From: Robert Haas
Date:
Subject: Re: Documentation tweak for row-valued expressions and null