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-tsvc
And now, the content of table
obce
is in clipboard and it can be pasted to
calc
without problems.
Great ! In one line of code, one learns a lot !
ReplyDeleteGreat ! In one line of code, ones learns a lot
ReplyDelete