Re: proposal \gcsv

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