| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>,"Fabien COELHO" <coelho(at)cri(dot)ensmp(dot)fr>,"Michael Paquier" <michael(at)paquier(dot)xyz>,"Pg Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: csv format for psql |
| Date: | 2018-11-26 19:01:20 |
| Message-ID: | 15870190-96fe-4e35-9f11-5e7004236f50@manitou-mail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
> A proposed fix is attached. print_csv_vertical() is left unchanged
> because it's not possible currently to end up with \. alone
> on a line with the expanded display
On second thought, it is possible
postgres=# \pset format csv
Output format is csv.
postgres=# \pset fieldsep_csv '.'
Field separator for CSV is ".".
postgres=# \x
Expanded display is on.
postgres=# select '' as "\" ;
\.
PFA an upgraded fix.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
| Attachment | Content-Type | Size |
|---|---|---|
| psql-csv-backslash-dot-fix-v2.txt | text/plain | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-11-26 19:12:53 | Re: pgsql: Integrate recovery.conf into postgresql.conf |
| Previous Message | Petr Jelinek | 2018-11-26 18:46:28 | Re: Copy function for logical replication slots |