Pavel Stehule's blog
Some notes about PostgreSQL
Friday, March 5, 2021
Thursday, February 25, 2021
pspg 4.3.0 released
I released new version of pspg. Now, there is an possibility to select rows, columns or block (by mouse or by keys) for export.
Sunday, January 24, 2021
dll of Orafce and plpgsql_check extensions for PostgreSQL 13 are available
I made dll files for x64 Microsoft Windows platform for Orafce and plpgsql_check extensions. orafce-3.14-pg13, plpgsql_check-1.15.1
Friday, January 15, 2021
pspg 4.0.0 released
I finished and released new version of pspg pager. New release has possibility to export content in CSV, TCVS, formatted text or INSERT format to file or clipboard.
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-tsvcAnd now, the content of table
obce
is in clipboard and it can be pasted to calc
without problems.
Monday, December 21, 2020
Orafce 3.14.0 released
I released Orafce 3.14.0. It is mostly bugfix release. Only implementation of
unistr
function is new.
The most important fixed issue was missing dependency between functions (n)varchar2
and (n)varchar2_transform
. An result of this missing dependency was bad order of functions in dump used by binary upgrade - and at end the binary upgrade was broken. After fixing the binary upgrade between major Postgres releases (by pg_upgrade
) is possible.
Sunday, November 8, 2020
redirect result from psql to libreoffice calc
Sometimes can be useful to forward output query result from console to spreadsheet. Unfortunately, it is not trivial task, but it is not pretty hard too.
I have a table "obce" (It is "municipality" in Czech language), and I would to see the content of this table in spreadsheet. Then I can redirect output in csv format to libreoffice.
Now I can run psql and write command:
postgres=# select * from obce \g (format=csv) | cat > tmpfile.csv; libreoffice --view --calc tmpfile.csv "--infilter='Text - txt - csv (StarCalc)':44,34,0,1"; rm tmpfile.csv
The psql from Postgres 13 is required.