> > 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