This article is like a box of chocolates! There's some quality-of-life tips, some best practices tips and some performance tips. I wish I knew earlier about \pset null '[NULL]'...
\pset null '[NULL]'
-databases -postgresql