You can do that now with a little code as follows:

SELECT column1,
       column2,
       CASE WHEN maybe_null_column IS NULL THEN 'NULL' ELSE
maybe_null_column END
  FROM your_table;

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ketema Harris
Sent: Thursday, May 24, 2007 12:42 PM
To: Pgadmin Support
Subject: [pgadmin-support] Feature Request

I was wondering if were possible in a future release of pgadmin, to
display 'null' in all query result panes where its an actual null value
instead of just a blank, because it is indistinguishable from an empty
string at this time.

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to