pgcli
pgcli copied to clipboard
dbcli
Postgres CLI with autocompletion and syntax highlighting
## Description Add autocommit mode. Add on error rollback. When autocommit_mode is set to false, users can manually commit or rollback the current transaction. When on_error_rollback is set to true,...
## Description If table_format is set to csv, when making any kind of sql syntax error, pgcli just doesn't say anything. Example: ``` psql://atr@localhost/tethys> test; Time: 0.017s ``` ## Your...
## Description With the **recent update** of `pgcli` there are problems raising when running scripts containing comments at the beginning/ending of scripts. Let's take these two scripts: **db/_scripts/01_demo_run.sql** ``` --Chesu...
## Description psql has a `\echo` command which appears as a syntax error in pgcli. ``` $ pgcli $DATABASE_URL Server: PostgreSQL 14.1 Version: 3.4.1 Home: http://pgcli.com postgres@db:postgres> \echo hi syntax...
## Description With psql, I can add this to ~/.inputrc: ``` $if Psql "\ee":"explain (analyze, buffers) " $endif ``` and (if psql was compiled with readline support), pressing alt-e will...
I've installed these packages: ``` $ pip install --upgrade pgcli $ pip install sshtunnel ``` I'm trying to run: ``` $ pgcli postgresql://someone:secret1@localhost:4567/mydb --ssh-tunnel anyone:[email protected]:789 ``` I get this output:...
## Description * Changed the `destructive_warning` config to be a list of commands that are considered destructive. This would allow you to be warned on `create`, `grant`, or `insert` queries....
## Description **CURRENT BEHAVIOR:** The footer, or result set decoration, at the end of the query output is "SELECT" but does not include the number of rows. Expected behavior for...
## Description When profiling Postgres queries with `EXPLAIN ANALYZE`, it is often necessary to copy the query to the system clipboard in order to feed the output to a visualisation...
For example: Select next completion item: ctrl + n instead tab Select previous completion item: ctrl + p instead tab+schift
