| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal \gcsv |
| Date: | 2020-03-28 14:39:02 |
| Message-ID: | 5005f4fc4034d68c7772bda610459236@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2020-03-28 15:05:51 | Re: [PATCH] Opclass parameters |
| Previous Message | David Steele | 2020-03-28 14:36:58 | Re: pgbench - refactor init functions with buffers |