pgcli icon indicating copy to clipboard operation
pgcli copied to clipboard

Postgres CLI with autocompletion and syntax highlighting

Results 146 pgcli issues
Sort by recently updated
recently updated
newest added

## 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: ![Screenshot from 2019-06-27 09-28-49](https://user-images.githubusercontent.com/38570962/60283446-ff3dec80-98bd-11e9-8da9-599ff0dee6be.png) 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](https://user-images.githubusercontent.com/46282492/59140839-19cb2700-89de-11e9-8d44-63ab56a2a574.PNG) 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...

bug

## 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...

easy