Re: Add \pset options for boolean value display

Vik Fearing <vik@postgresfriends.org>

From: Vik Fearing <vik@postgresfriends.org>

To: Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston" <david.g.johnston@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-07-05T12:41:27Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add \pset options for boolean value display
- 645cb44c5490 19 (unreleased) landed

On 25/06/2025 00:30, Tom Lane wrote:
> "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
> Do we really want this?


Yes, many of us do.


> 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.


You mean scripts that don't use --no-psqlrc?  Those scripts are already 
bug ridden.

-- 

Vik Fearing