2018-04-07 14:23 GMT+02:00 Daniel Verite <dan...@manitou-mail.org>:
> Peter Eisentraut wrote:
> > Another thought: Isn't CSV just the same as unaligned output plus some
> > quoting? Could we add a quote character setting and then define --csv
> > to be quote-character = " and fieldsep = , ?
> Plus footer set to off. So --csv would be like
> \pset format unaligned
> \pset fieldsep ','
> \pset footer off
> \pset unaligned_quote_character '"'
> I guess we'd add a \csv command that does these together.
> There would still be some discomfort with some of the issues
> discussed upthread. For instance
> psql -F ';' --csv
> is likely to reset fieldsep to ',' having then a different outcome than
> psql --csv -F';'
> And there's the point on how to come back from \csv to another
> output, given that it has overwritten "footer" that is used across
> all formats, and fieldsep used by unaligned.
> So a user might need to figure out anyway the
> intricaties behind \csv, if it's not an independant format.
> On the whole I'm inclined to resubmit the patch with
> fieldsep_csv and some minor changes based on the rest
> of the discussion.
> Best regards,
> Daniel Vérité
> PostgreSQL-powered mailer: http://www.manitou-mail.org
> Twitter: @DanielVerite