PATCH: psql boolean display
Phil Sorber <phil@omniti.com>
From: Phil Sorber <phil@omniti.com>
To: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2012-08-19T16:02:31Z
Lists: pgsql-hackers
Attachments
- psql-bool-display.patch (application/octet-stream) patch
Hello all, I am providing a patch to allow you to change the output of a boolean value in psql much like you can do with NULL. A client requested this feature and we thought it may appeal to someone else in the community. The patch includes updated docs and a regression test. The code changes themselves are pretty simple and straightforward. Example from the regression test: SELECT true, false; bool | bool ------+------ t | f (1 row) \pset booltrue 'foo' \pset boolfalse 'bar' SELECT true, false; bool | bool ------+------ foo | bar (1 row) \pset booltrue 't' \pset boolfalse 'f' SELECT true, false; bool | bool ------+------ t | f (1 row) As always, comments welcome. Thanks.