redirect query result from psql to LibreOffice Calc by using clipboard
psql
as classic TUI application doesn't support clipboard. But it isn't hard to redirect result to clipboard in good format for LibreOffice.
First You need an psql
from PostgreSQL 13 release. Next you need some clipboard manager application like xclip
(XWindows) or pbcopy
(MacOS) or wl-clipboard
(Wayland).
After some testing I found so LibreOffice Calc reads tsv format without problems (for numbers and texts without tabs). It uses identification application/x-libreoffice-tsvc
for this format.
postgres=> select * from obce \g (format=csv tuples_only=off csv_fieldsep='\t') | wl-copy -t application/x-libreoffice-tsvcAnd now, the content of table
obce
is in clipboard and it can be pasted to calc
without problems.
2 Comments:
Great ! In one line of code, one learns a lot !
Great ! In one line of code, ones learns a lot
Post a Comment
Subscribe to Post Comments [Atom]
<< Home