On 4/1/18 03:27, Pavel Stehule wrote: > I don't share option so CSV format should be exactly same like CSV COPY. > COPY is designed for backups - and header is not too important there. > When I seen some csv, then there usually header was used.
I think in practice a lot of people use COPY also because it's a nice way to get CSV output, even if it's not for backups. The options that COPY has for CSV are clearly designed around making the output compatible with various CSV-variants. If we create another way to do CSV in psql, it would be totally confusing if some of the options are the same and some are different or missing. 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 = , ? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
