Use tmpfile config for psql copy

This is useful because the Postgres process in our deployment can't
access the e.g. /tmp dir Python writes tempfiles to by default. Now we
can specify where our intermediate CSV files are written to so that
postgres can read them.