Re: Add \pset options for boolean value display - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add \pset options for boolean value display
Date
Msg-id 1174075.1750804258@sss.pgh.pa.us
Whole thread Raw
In response to Add \pset options for boolean value display  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Mar 20, 2025 at 8:24 PM David G. Johnston <
> david.g.johnston@gmail.com> wrote:
>> It's \pset null for boolean values

> v1, Ready aside from bike-shedding the name.

Do we really want this?  It's the sort of thing that has a strong
potential to break anything that reads psql output --- and I'd
urge you to think that human consumers of psql output may well
be the minority.  There's an awful lot of scripts out there.

I concede that \pset null hasn't had a huge amount of pushback,
but that doesn't mean that making boolean output unpredictable
will be cost-free.  And the costs won't be paid by you (or me),
but by people who didn't ask for it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson
Next
From: Melanie Plageman
Date:
Subject: Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum.