setting display format of booleans in psql

Hello

there is not any possibility to change boolean output format.

Regards

Pavel Stehule

2011/8/6 Henry House <hajhouse@houseag.com>:

Pavel Stehule wrote:

Hello

there is not any possibility to change boolean output format.

Regards

Pavel Stehule

2011/8/6 Henry House <hajhouse@houseag.com>:

Is there a way to set the display format of boolean values in psql just
as one can set the display of nulls using \pset null <some string>? I
find presentation of true as 't' and false as 'f' rather poor since 't'
and 'f' do not look very different from each other. I'd like to instead
get 'TRUE' or 'FALSE'.

Nothing in the manual page for psql seems helpful.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

But I'm sure you could write yourself a (non-volatile?) function which
would wrap your booleans whenever select * is NOT used.

select id, name, bw(isAlien) from individual;

create or replace function bw(boolean b)
returns char as &&

begin;
/ /if b then
return 'F';
else
return 'T';
end;
&&
etc.
return