Re: csv format for psql
Gavin Flower <gavinflower@archidevsys.co.nz>
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: Fabien COELHO <coelho@cri.ensmp.fr>,
Daniel Verite <daniel@manitou-mail.org>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
Pavel Stehule <pavel.stehule@gmail.com>,
David Steele <david@pgmasters.net>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-03-31T08:44:29Z
Lists: pgsql-hackers
On 31/03/18 21:33, Fabien COELHO wrote: > > Bonjour Daniel, > >> For csv, Fabien and Peter expressed the opinion that we shouldn't >> create another fieldsep-like variable specifically for it, but instead >> reuse fieldsep. That's what my latest patch does. >> >> Now it turns out that sharing fieldsep comes with some problems. > > Personnaly I do not have any problem with CSV defaulting to '|' > separator, given that anyway people often use anything but a comma for > the purpose, including '|'. > > However Pavel wants to block the patch on this point. Too bad. > > Maybe you can do (again) a patch with a 'fieldsep_csv' or whatever > additional variable? Not sure about 'recordsep'... > > And then we forward to committers both version and they can chose > whatever they think best, including not committing anything? > Would suggest the choice of 'fieldsep_csv' out of those two (a record would correspond to the whole row), and the default being a comma. Cheers, Gavin
Commits
-
Add CSV table output mode in psql.
- aa2ba50c2c13 12.0 landed
-
Reorganize format options of psql in alphabetical order
- add9182e5908 12.0 landed
-
Complete TODO item:
- 862b20b38228 8.0.0 cited