select .. into outfile works great, but there doesn't seem to be a way to include column headers. Some creative workarounds have been proposed on SO (https://stackoverflow.com/questions/5941809/include-headers-when-using-select-into-outfile) but nothing convenient.

In postgres, as you probably know, export is done with the copy command. Here are their docs (https://www.postgresql.org/docs/current/static/sql-copy.html) though I'm not sure how useful they are to us here.

I wanted this to have Issue Type = New Feature, but the only option Jira gave me was "Bug". Please feel free to change any of that metadata as you see fit.