Обсуждение: setting display format of booleans in psql
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.
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 >
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