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.