Re: proposal - support tsv output format for psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal - support tsv output format for psql
Date
Msg-id CAFj8pRDCr2PN=rPZJb-dQyUw_Gs_c3X8HHeDhF7osYdLgYuLkg@mail.gmail.com
Whole thread Raw
In response to Re: proposal - support tsv output format for psql  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers


st 23. 12. 2020 v 17:38 odesílatel Andreas Karlsson <andreas@proxel.se> napsal:
On 12/23/20 7:18 AM, Pavel Stehule wrote:> I am playing with clipboard
on Linux, and I found a way, how to redirect
> psql output to clipboard via wl-copy or xclip and then to Libre Office.
> Now it looks so best format is tsv
>
> select * from pg_database \g (format=tsv) | wl-paste -t
> application/x-libreoffice-tsvc
>
> Implementation of tsv format should not be hard.
>
> What do you think about this?

I wonder if it would not make more sense to add support for text/csv to
LibreOffice's clipboard code rather than implementing tsv in PostgreSQL.
The tsv format is even less clearly defined than the csv format which at
least has one RFC even if many homebrew their own versions of it.

yes, but it is out of my competitions. But after some research, I don't think this support is necessary, because the tsv implemented by LO is much more like CSV with \t as delimiter.

Regards

Pavel


 

Andreas

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Discarding DISCARD ALL
Next
From: Zhihong Yu
Date:
Subject: Postgres Spark connector