Video about pspg pager usage

I prepared short video about pspg.

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.

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

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.

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.

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.

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.