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.