Thread: 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.

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: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] 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

Here's another, quicker way to do it.

SELECT column1,      column2,      COALESCE(maybe_null_column, 'NULL') FROM your_table;

Note: If maybe_null_column is not a character data type,     then you need to coerce it. ie: maybe_null_column::text

Hi,

I am using PgAdminIII 1.6.3 on windows xp, I changed the font size in the
preferences dialog box to be size 12 when I restarted PgAdmin and went to
preferences dialog box I could not see the change font button because it was
beyond the right edge of the window. I was unable to resize the preferences
dialog box and so I could not change the font back. I had to the windows
registry and delete the pgAdminIII key to get the font size back to the
default size. I experimented with a bunch of font sizes and the only font
size that wok are 8 and 9 anything above that and the window is too small.

Thanks
Adib

Ketema Harris wrote:
> 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.

This is already implemented for the next version:
http://www.pgadmin.org/docs/dev/options-tab3.html

Regards, Dave

Adib Saikali wrote:
> Hi,
> 
> I am using PgAdminIII 1.6.3 on windows xp, I changed the font size in the
> preferences dialog box to be size 12 when I restarted PgAdmin and went to
> preferences dialog box I could not see the change font button because it was
> beyond the right edge of the window. I was unable to resize the preferences
> dialog box and so I could not change the font back. I had to the windows
> registry and delete the pgAdminIII key to get the font size back to the
> default size. I experimented with a bunch of font sizes and the only font
> size that wok are 8 and 9 anything above that and the window is too small.

I cannot reproduce this on the current development code. This is likely 
because some of the sizing code has been rewritten though. So the next 
release should be fine.

Thanks for the report.

Regards, Dave