Re: setting display format of booleans in psql

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