Sunday, October 27, 2019

watch mode for pspg

I released version 2.5.0 of pspg.

Major feature of this release is possibility to bypass psql and take data from Postgres directly (option: -q, --query). Now the pspg can be used like very simple Postgres client. The main benefit of this feature is in relation to new watch mode. The result of query can be refreshed every n seconds (option: -w). It's allow to use the pspg for simple fresh data presentations, for simple monitoring. The refreshing can be stopped/started by pressing space.

Sunday, October 20, 2019

dll for plpgsql_check 1.7.6 are available for PostgreSQL 10, 11, and 12

I prepared dll libraries. You can load it from url


  1. Download, unzip and choose related dll file
  2. rename to plpgsql_check.dll and copy to PostgreSQL's lib directory (Program Files/PostgreSQL/10/lib)
  3. copy plpgsql_check-1.7.sql and plpgsql_check.control to PostgreSQL's share/extension directory (PostgreSQL/10/share/extension).
  4. with super user rights (user postgres) run command CREATE EXTENSION plpgsql_check;.
It can needed installed a Microsoft Visual C++ 2015 SP1 Redistributable Package

Please, check it.

precompiled libraries for orafce 3.8 for PostgreSQL 10, 11 and 12

I upload precompiled libraries to These libraries are 64bit only (there is not 32bit build for Postgres 11 and 12). For 32bit or older PostgreSQL releases, please, use older orafce builds. Windows build is partially reduced - there are not support for PLVlex for PostgreSQL 10 and 11 (due compilation problems), and there are not support for utl_file (due crash in these functions - I am not able to fix it on MSWIN platform).

Installation - a) install Visual C++ Redistributable for Visual Studio 2015, b) copy *.sql and *.control to ../PostgreSQL/version/share/extensions and *.dll (after to rename to just orafce.dll to ../PostgreSQL/version/lib.