Re: csv format for psql
Fabien COELHO <coelho@cri.ensmp.fr>
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Michael Paquier <michael@paquier.xyz>
Cc: Daniel Verite <daniel@manitou-mail.org>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-11-07T09:01:20Z
Lists: pgsql-hackers
Bonjour Michaël, > First, it seems to me that it is necessary to overcomplicate the > interface of psql for that. Most of the other formats don't have their > own switch, and it is perfectly possible to use CSV format with just > --pset=format=csv. Although this work, it is not very user friendly nor easy to memorize. Quite a few direct format options already exists, eg -A --no-align (yuk, -A means not to align... :-(), -H --html... In this context "--csv" looks pretty unambiguous and more useful, so I would be in favor of keeping this option. > -C could also be useful for other things, say compression. Sure. -C is *NOT* used for --csv in the patch, although it may have been with an earlier version? > In the regression tests, "col 9" is wanted with a newline? Yes, the point is to check whether quoting & escaping are triggered appropriately in column names and values. -- 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