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