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.