Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Re: Feature Request - Show Null

Re: Feature Request - Show Null



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



Home | Main Index | Thread Index

top