Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
If sqlcl is started with /nolog argument and the connect command is used afterwards, pspg fails as described in issue #228. If you connect directly using a connect string provided as an argument, pspg is working for the current session only. As soon as a new connect is issued, all subsequent pspg command will fail with SQL Error: Closed Connection.
This patch ensures that the current sqlcl connection handler is always assigned to the sqlcl executor.
okbob
commented
1 year ago
If sqlcl is started with
/nologargument and theconnectcommand is used afterwards,pspgfails as described in issue #228. If you connect directly using a connect string provided as an argument,pspgis working for the current session only. As soon as a newconnectis issued, all subsequentpspgcommand will fail withSQL Error: Closed Connection.This patch ensures that the current sqlcl connection handler is always assigned to the sqlcl executor.