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.
Some notes about PostgreSQL
I released new version of pspg. Now, there is an possibility to select rows, columns or block (by mouse or by keys) for export.
I made dll files for x64 Microsoft Windows platform for Orafce and plpgsql_check extensions. orafce-3.14-pg13, plpgsql_check-1.15.1
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.
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.
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.
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.
Compiled dll of Orafce extension 3.13 can be downloaded from url https://github.com/orafce/orafce/files/5264898/orafce_win_binary.zip