SQL Loading CSV Errors and Fixes

Author here. I have \copy'ed lots of CSVs into Postgres. I thought I'd share command line fixes for the most common errors I've seen.