pgcli
pgcli copied to clipboard
Postgres CLI with autocompletion and syntax highlighting
## Description `\ns` with multiline and Vim input mode saves the query when pressing Enter in Insert mode, when it should insert a newline instead Usually when using multiline Vim...
## Description pgcli crashes with segmentation fault on some queries: ``` goszakupki@(none):goszakupki> select * from purchase where publish_date > '2019-07-20'::date; [1] 54595 segmentation fault pgcli -U goszakupki goszakupki ``` No...
It is common practice to right align header and values in numeric columns, see for example https://ux.stackexchange.com/q/24066. Or more precisely, align to decimal point. To reproduce: ```sql SELECT name, salary...
## Description After installing via `conda` on Ubuntu 19.04, `psql` was working but `pgcli` wasn't:  I *was* able to make things work, by adding `'/tmp'` to...
It would be really helpful to warn the user who leaves his session (quitting pgcli) that in case of an existing transaction, he will need to **explicitly commit or rollback**...
## Description  Title color of tables is white foreground with grey background so it's hard to distinguish. This issue occurs in `mycli` too. ## Your environment - [ ]...
## Description Noob using `pgcli` here. I was trying to configure my environment, and at some point, I started getting always the same error, about a bad DSN in my...
## Description ``` denis ~ $ pgcli -h localhost -U postgres -d postgres Traceback (most recent call last): File "/usr/bin/pgcli", line 9, in load_entry_point('pgcli==0.20.1', 'console_scripts', 'console')() File "/home/denis/.local/lib/python3.5/site-packages/click/core.py", line 716,...
## Description In psql I can use \i to load a file which contains a series of additional \i commands. This makes it simple to run commands from a single...
## Description The format of array types is too pythonic - includes the `u''` prefix for strings, types for datetimes/decimals, etc. Need to format all the elements of the array...