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
.
perfect, thanks :-)
ReplyDelete