st 23. 12. 2020 v 17:38 odesÃlatel Andreas Karlsson <andr...@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 > >