Horton

Re: proposal \gcsv

Erik Rijkers <er@xs4all.nl>

View thread View on postgr.es
From: Erik Rijkers <er@xs4all.nl>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Vik Fearing <vik@postgresfriends.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-03-28T14:39:02Z
Lists: pgsql-hackers 
On 2020-03-28 15:06, Daniel Verite wrote:
> 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.

Ah yes, that works.  I had not seen that psql -P option.  Thanks!

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