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.

Wednesday, September 25, 2019

pspg can be used like csv viewer

Last week I worked on CSV parser and formatter. Now I integrated both components to `pspg`, and then `pspg` can be used like csv viewer.

cat obce.csv | pspg --csv

Wednesday, September 11, 2019

pspg 2.0.2 is out

there is just one new feature - sort is supported on all columns, not only on numeric columns.

Sunday, September 8, 2019

pspg 2.0.1 released

I released new version of pspg 2.0.1. I started work on pspg three years ago, and now there are almost all features what are possible with this design - the data are stored in original form (created by some sql client). The alternative of pspg can be sophisticated CSV viewers, because psql can produce a content in CSV format. Maybe (in far future) pspg 3.0 will be based on internal CSV storage with formatting on pspg side. But it is not a plan for few next years (or somebody can do it). So last month I wrote vertical cursor support (necessary for next step), and last week I finished "sort by column" feature. The sort command has sense only on numeric columns (works with numbers only - I really would not supply ORDER BY clause in SQL). With this limit is has maybe interesting feature - some size units (kB, MB, GB, TB) are supported.

Please, use it freely. And if you like this software, send me a postcard from your country - pspg is postcardware.

Update: Version 2.0.2 supports sort on any column (not only on numeric columns)

Tuesday, September 3, 2019

pspg supports sort by selected column

Master branch of pspg supports sort by column selected by vertical cursor.

Why I wrote this feature? You can try to list of tables in psql by \dt+ command. The result is sorted by schema and by name. Sometimes can be interesting to see result ordered by table's sizes. Now it is easy. Press Alt-v to show vertical cursor. Later move to right to "Size" column. Then press d as descendent sort. You can get resuly like attached screenshot:

The sort is working only on numeric columns (but units used by psql are supported)

Update: Now, you can test this feature in version 1.9.0.