Saturday, December 14, 2019

pspg themes - what you use it?

This year I finish more projects - pspg - there are watch mode, integrated readers from csv and tsv, and vertical cursor and sort on client side.

plpgsql_check can detect some basic sql injection problems and has integrated profiler now. Lot of bug was fixed. These tools works well and I am almost satisfied with their functionality.

Today some lighter topic. I did screenshot of any theme supported by pspg. What theme do you use, or what theme do you prefer?

Thursday, November 21, 2019

Compilation Orafce on CentOS 7 against pgdg repo

if somebody has problem with missing clang like "clang: command not found", then workaround can be running make with variable:

  with_llvm=no make -e

Tuesday, November 19, 2019

using pspg for SQLite

pspg can be used for SQLite too. Not directly, because sqlite client is not too rich. But there are some possibilities:

a) you can use litecli. litecli is able to use pspg

b) generate CSV from sqlite client - this format is well readable for pspg

sqlite3 -csv -header testdb.db 'select * from foo2' | pspg --csv --csv-header=on --double-header

Thank you for tip to Trent W. Buck.

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 plpgsql_check-1.7.6-x64-win.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.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 https://www.microsoft.com/en-US/download/details.aspx?id=48145.

Please, check it.

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

I upload precompiled libraries to postgres.cz/files/orafce-3.8.0-x64.zip. 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