Re: csv format for psql
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Daniel Verite <daniel@manitou-mail.org>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-03-09T16:48:00Z
Lists: pgsql-hackers
2018-03-09 8:40 GMT+01:00 Fabien COELHO <coelho@cri.ensmp.fr>: > > About "fieldsep_csv", I do not like much the principle of having different >>>> output variables to represent the same concept depending on the format. I >>>> would rather have reused fieldsep as in your previous submission and set it >>>> to "," when under --csv. >>>> >>> >>> yes >>> >>> >> how will be possible to set different separator ';'? I don't see it with >> described design >> > > Indeed, it should be possible. I think that the following should be made > to work: > > psql --csv -P fieldsep=; -c 'TABLE foo' > foo.csv > > So that it can be changed the semi-colon (or tab or whatever) style if > required. > ok, then all is ok Regards Pavel > > -- > Fabien. >
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