Horton

Re: csv format for psql

Daniel Verite <daniel@manitou-mail.org>

View thread View on postgr.es
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Isaac Morland" <isaac.morland@gmail.com>
Cc: "Joshua D. Drake" <jd@commandprompt.com>,"David G. Johnston" <david.g.johnston@gmail.com>,"Pavel Stehule" <pavel.stehule@gmail.com>,"Fabien COELHO" <coelho@cri.ensmp.fr>,"David Steele" <david@pgmasters.net>,"PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
Date: 2018-03-29T12:42:01Z
Lists: pgsql-hackers 
	Isaac Morland wrote:

> The actual reason I'm posting this is because some of the discussion has
> made me a bit confused: there is already a CSV format defined for the COPY
> command and used by the psql \copy. I just want to check that what is being
> discussed here would use the exact same format as the existing CSV COPY

Please see the start of the thread at
https://www.postgresql.org/message-id/a8de371e-006f-4f92-ab72-2bbe3ee78f03%40manitou-mail.org
where what is proposed is compared to what \copy and COPY
already provide.

About the CSV acronym itself, the COPY documentation
https://www.postgresql.org/docs/current/static/sql-copy.html
already refers to it as "Comma Separated Values", even though
as we know, the delimiter is user-configurable.
There's no difference in psql that would justify a different wording.

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: