Sunday, November 19, 2017

short post again

I did some few changes and pspg should supports pgcli and mysql too.

Please, test it.

Friday, November 17, 2017

pspg suppports mysql too

I fixed some issues, and now the pspg can be used with mysql
MariaDB [(none)]> use sakila
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

MariaDB [sakila]> pager ~/src/pspg-master/pspg -s 2 -X
PAGER set to '~/src/pspg-master/pspg -s 2 -X'

MariaDB [sakila]> select * from nicer_but_slower_film_list limit 10;

Tuesday, November 14, 2017

short post: new release of pspg is available

Now, aligned scrolling in expanded mode is implemented. Some bugs are fixed too. Please, test it.

Source: https://github.com/okbob/pspg

Saturday, October 28, 2017

bugfix of precompiled dll of Orafce 3.6.1

Precompiled libraries of Orafce are available on url: https://postgres.cz/files/orafce-3.6.1.zip.

Orafce 3.6.0 for PostgreSQL 9.4-10.0 compiled for windows

Precompiled libraries of Orafce are available on url: https://postgres.cz/files/orafce-3.6.0.zip.

Friday, October 27, 2017

plpgsql_check 1.2.2 for windows (for PostgreSQL 9.4-10)

I compiled the plpgsql_check by Visual Studio 2015 Express. The dll for PostgreSQL 9.4, 9.5, 9.6 and 10, for x86 and x64 platform are available in zip archive https://postgres.cz/files/plpgsql_check-1.2.2-1-mswin.zip.

Installation

  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.2.sql and plpgsql_check.control to PostgreSQL's share/extension directory (PostgreSQL/10/share/extension).

It can needed installed a Microsoft Visual C++ 2015 SP1 Redistributable Package https://www.microsoft.com/en-US/download/details.aspx?id=48145.

Please, check it.

Friday, October 6, 2017

PostgreSQL 10 - article

I wrote a article about PostgreSQL https://www.root.cz/clanky/postgresql-10-drsne-rozbehnuty-slon/. It is in Czech language, but Google Translator should to work.