Re: Add \pset options for boolean value display

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add \pset options for boolean value display
Date: 2025-06-25 18:03:01
Message-ID: a4d9aae6-a30a-42c3-92fd-1dbb00fc6dd4@manitou-mail.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David G. Johnston wrote:

> > It's \pset null for boolean values
> >
>
> v1, Ready aside from bike-shedding the name.

An annoying weakness of this approach is that it cannot detect
booleans inside arrays or composite types or COPY output,
meaning that the translation of t/f is incomplete.

Also it reminds of a previous discussion (see [1]) where pretty much
the same idea was proposed (and eventually rejected at the time).

[1] https://postgr.es/m/56308F56.8060908%40joh.to

Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Pyhalov 2025-06-25 18:07:22 Re: SCRAM pass-through authentication for postgres_fdw
Previous Message Aleksander Alekseev 2025-06-25 17:58:05 Re: [PATCH] Correct src/backend/lib/README