\copy (select fields from table where something=otherthing) to '/tmp/test.csv' with HEADER CSV;