pgcli
pgcli copied to clipboard
dbcli
Postgres CLI with autocompletion and syntax highlighting
## Description As the title of the issue states quitting less is also closing pgcli. A simple query like this opens up `less` ``` select G.d_ID, avg(G.g_Price) as g_AvgPrice from...
Transactions
It would be nice if pgcli had some fancy handling for transactions. Things I could imagine: - Always start a transaction on startup. COMMIT/ROLLBACK would automatically start a new one....
Ref: http://stackoverflow.com/questions/4480381/postgres-sql-fail-on-script-error pgcli currently supports changing the on-error behavior when we run multiple statements. But this is controlled via the config file. It'll be good to change the ON_ERROR behavior...
When user types in `\h `, completer has to suggest SQL terms for which help is available. Those terms can be got from executing `\h` without parameters.
Users of a database can be suggested after the OWNER keyword in CREATE DATABASE. eg: ``` CREATE DATABASE discourse_development OWNER ``` Extensions in a database can be suggested for CREATE...
## Description Messages logged by functions are printed in reverse order, with `None` between lines. ```sql BEGIN; CREATE FUNCTION demo() RETURNS VOID AS $_$ BEGIN RAISE NOTICE 'first'; RAISE NOTICE...
## Description ``` > pgcli postgres://xxx:xxx@localhost:5432 Traceback (most recent call last): File "", line 198, in _run_module_as_main File "", line 88, in _run_code File "C:\Users\admin\.local\bin\pgcli.exe\__main__.py", line 4, in File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\pgcli\main.py",...
## Description When I start typing a statement, and pgcli suggests the complete statement in gray, and I just want to accept it, I try to hit Tab and instead...
Query the table, the table has the Chinese language to display the garbled code 
**This is just a draft!** It seems that we sometimes have Windows-only issues (mostly installation issues, hopefully). Having a CI that runs on Windows looks useful.
