Here's a little tip if you're using psql to look at stuff in
a PostgreSQL database. Create a file called .psqlrc in your home
directory, and put this in it:
\pset null <nil>
Then columns containing null values won't just be blank when you select them, and you'll be able to distinguish null from empty text values.