Re: [GENERAL] Making NULLs visible.

> > Is there a way to make postgreSQL 'show' nulls rather than have them appear
> > as blank fields?

> I am always looking for suggestions on how to display nulls.  It is on
> the TODO list.

I'd suggest a query option.  The query option could filter the displayed
data through a temporary table which would do a NULL to char() conversion
as it were.

similar to
psql-> set query option id null as "NULL"

then the interface would do the following if given a query

query passed to psql

select a, b, from mydata;

psql would interpret as

create table temp (a  text, b  text);

and then run a query to populate temp casting the values of a b from
mydata as necessary and taking null values and setting them to what the
user specified (a good choice would be "NULL" of course).

steve