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: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "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-29T11:53:55Z
Lists: pgsql-hackers 
	David G. Johnston wrote:

> Could someone post how captions, rows-only, and footer pset settings factor
> into this?  Specifically are they fixed to on/off or will they hide/show if
> users request them explicitly?

This is described in the doc with:

+	   <para><literal>csv</literal> format writes columns separated
+	   by <literal>fieldsep</literal>, applying the CSV quoting rules
+	   described in RFC-4180 and compatible with the CSV format
+	   of the <command>COPY</command> command.
+	   The header with column names is output unless the
+	   <literal>tuples_only</literal> parameter is <literal>on</literal>.
+	   Title and footers are not printed.
+	   </para>


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: