Horton

Re: proposal \gcsv

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Erik Rijkers <er@xs4all.nl>, Vik Fearing <vik@postgresfriends.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-03-28T14:09:34Z
Lists: pgsql-hackers 
so 28. 3. 2020 v 15:06 odesílatel Daniel Verite <daniel@manitou-mail.org>
napsal:

>         Erik Rijkers wrote:
>
> > 2. let the psql command-line option '--csv' honour the value given by
> > psql -F/--field-separator (it does not do so now)
> >
> > or
> >
> > 3. add an psql -commandline option:
> >     --csv-field-separator
>
> Setting the field separator on the command line is already supported
> through this kind of invocation:
>
> psql --csv -P csv_fieldsep=$'\t'
>
> bash expands $'\t' to a tab character. Other shells might need
> different tricks.
>

We have named parameters in shell, but not in psql



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

Commits

  1. Allow psql's \g and \gx commands to transiently change \pset options.