Re: csv format for psql

Daniel Verite <daniel@manitou-mail.org>

From: "Daniel Verite" <daniel@manitou-mail.org>
To: "David Fetter" <david@fetter.org>
Cc: "Fabien COELHO" <coelho@cri.ensmp.fr>,"Pavel Stehule" <pavel.stehule@gmail.com>,"PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
Date: 2018-03-07T20:08:43Z
Lists: pgsql-hackers
	David Fetter wrote:

> This seems pretty specialized.  If we're adding something new, how about 
> 
>    psql --format=csv -o foo.csv -c 'TABLE foo'

It's a bit easier to memorize than -P format=csv,
but psql doesn't have any long option that does not a have a short
form with a single letter, and both -F and -f are already taken.
Contrary to -C that isn't used until now.

> Or we could stick with:
> 
>    psql -P format=csv -o foo.csv -c 'TABLE foo'

That already works as of the current patch, just
like with the other formats.

Best regards,
-- 
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite


Commits

  1. Add CSV table output mode in psql.

  2. Reorganize format options of psql in alphabetical order

  3. Complete TODO item: