new release 3.15.0 of Orafce extension

I released version 3.15.0. Thank to Giles Darold (author of ora2pg, pgbadger, pgFormatter, ..) work you can use Oracle's regexp functions like New regexp_like(), regexp_count(), regexp_instr() and regexp_substr(). https://github.com/orafce/orafce/releases/tag/VERSION_3_15_0

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.