A Better Null Display Character
postgres
Written November 27, 2015
By default, psql will display null values with whitespace. This makes it
difficult to quickly identify null values when they appear amongst a bunch
of other data. You can pick a better display value for null characters with
\pset null. My preference is the following:
\pset null 'Ø'
I have this in my .psqlrc file so that it is used by default every time.