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