Re: csv format for psql

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-02-12T14:39:31Z
Lists: pgsql-hackers
2018-02-12 15:33 GMT+01:00 Daniel Verite <daniel@manitou-mail.org>:

>         Pavel Stehule wrote:
>
> > some like "\pset format csv , header_off
>
> If we did that, we'd need to reconsider the interactions
> of this with \t on|off and \pset footer on|off
> and how to keep things consistent with the unaligned
> format.
>

ok



> I feel like it's not worth the trouble.
> We can still add this later if users are confused with
> the interface, but that interface is already well
> established with the unaligned format.
>
> > 2. if we support csv format, then we can introduce \gcsv xxx | gnuplot
> ....
>
> I thought committers rejected this because they didn't want a
> new variant of \g
> The csv format makes it possible to not add any new \g-style
> metacommand and inject csv into the existing ones.
>
>
ok


>
> 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: