Re: Add \pset options for boolean value display
| От | David G. Johnston |
|---|---|
| Тема | Re: Add \pset options for boolean value display |
| Дата | |
| Msg-id | CAKFQuwZQUCiCc3c1JESS=q33maA2y_A4K-ZyZ1u_v8EnEG869Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Add \pset options for boolean value display ("Daniel Verite" <daniel@manitou-mail.org>) |
| Список | pgsql-hackers |
On Wed, Jun 25, 2025 at 11:03 AM Daniel Verite <daniel@manitou-mail.org> wrote:
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
Arrays are probably doable. The low volume of composite literal outputs is not worth worrying about.
or COPY output,
meaning that the translation of t/f is incomplete.
pset doesn't affect COPY output ever so this doesn't seem problematic.
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
Ok, so yes, I really want this hack in psql. It fits with pset formats and affects our \d and other table-producing meta-commands. Plus I'd like to use it for documentation examples.
Maybe that's enough to change some decade-old opinions. Mine's apparently changed since then.
David J.
В списке pgsql-hackers по дате отправления: