Attached is a v2 fixing the bugs you mentioned, and adding ---csv/-C as discussed upthread. I'll add some regression tests shortly.
Basically I'm waiting for the version with regression tests before reviewing.
It is unclear whether committer will like it.
From my point of view being able to simply set postgres to generate csv is fine with me, with example uses such as:
psql --csv 'TABLE Stuff;' > stuff.csv
So that having the --csv option to turn to "full csv", i.e. set the format and various seperators as expected, would be a nice have.
There is commad -c and it should be used. The --csv options should not to have a parameter. I don't like a idea to have more options for query execution.