> Maybe some \csv command could set the format to csv, fieldsep to ",", > tuples_only to on, recordsep to '\n'? Not sure whether it would be > acceptable, though, and how to turn it off once turned on... Probably an > average (aka not good) idea:-)
Thanks for reviewing this patch!
Attached is a v2 fixing the bugs you mentioned, and adding ---csv/-C as discussed upthread. I'll add some regression tests shortly.
About the default separator, the approach taken by this patch is that the csv output is equivalent to unaligned with csv quoting, so it has the same behavior and follows the options of the unaligned mode as much as possible.
That seemed like a good idea to me when I wrote it, but maybe a better idea would to have a new \pset fieldsep_csv parameter with its own command-line option, and ignore {fieldsep, fieldsep_zero, recordsep, recordsep_zero} for this format, just like they are being ignored for HTML, or latex, or asciidoc... Does anyone who think that csv should be added care about this "alignment" with unaligned? :)
good idea
Pavel
Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite