Pages

Tuesday, December 22, 2020

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-tsvc
And now, the content of table obce is in clipboard and it can be pasted to calc without problems.

2 comments: