Re: Feature Request - Show Null - Mailing list pgadmin-support

From Melvin Davidson
Subject Re: Feature Request - Show Null
Date
Msg-id 2CC69F840555CB43B04195F218CCB57F8F596B@COENGEX01.cctus.com
Whole thread Raw
In response to Feature Request  (Ketema Harris <ketema@gmail.com>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: "Melvin Davidson"
Date:
Subject: Re: Feature Request -Show NULL
Next
From: "Adib Saikali"
Date:
Subject: Bug Report: Preferences Dialogbox does not resize after I change the font size