Re: csv format for psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: csv format for psql
Date
Msg-id 38e5c398-33a5-4ac1-ad36-30e130882314@manitou-mail.org
Whole thread Raw
In response to Re: csv format for psql  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)