Friday, April 24, 2020

pgcli integrated support for pspg

pgcli is nice TUI client for Postgres. Against psql it has significantly modern look with more aggressive autocomplete support.

When I tested this client, I found one significant issue (against psql). It was pretty slow when larger than small result had to be displayed. The most slow operation is result formatting to tabular format. This is hard task for interpret language and pgcli is written in Python. I proposed a move this operation to pspg. Yesterday a necessary patch was committed.

It requires some pgcli configuration - see ~/.config/pgcli/config file:
pager = pspg --csv --rr=2 --quit-if-one-screen --ignore-case --csv-header=on --double-header
table_format = csv
row_limit = 0

Now, the result is processed with similar speed like in psql and work with pgcli is much more comfortable. Thanks to all authors of pgcli.


At April 24, 2020 at 12:53 AM , Anonymous Jiří Fejfar said...

perfect, thanks :-)


Post a Comment

Subscribe to Post Comments [Atom]

<< Home