pgcli
pgcli copied to clipboard
dbcli
Postgres CLI with autocompletion and syntax highlighting
As discussed [here](https://github.com/dbcli/pgcli/discussions/1509), there is no autocompletion when setting the search_path (`SET search_path TO bar`). [As suggested](https://github.com/dbcli/pgcli/discussions/1509#discussioncomment-13276295), the first autocompletion can easily be implemented by adding `search_path TO` here: https://github.com/dbcli/pgcli/blob/435cf7f2843c1a161ad63d72b75b91d1ccba8200/pgcli/packages/pgliterals/pgliterals.json#L230
In `pgcli` we haven't auto completion for `version()` function. So there is no completetion suggestion for below command. `SELECT VERSION();` ``` $ pgcli -v Version: 4.3.0 ```
https://github.com/dbcli/pgcli/blob/435cf7f2843c1a161ad63d72b75b91d1ccba8200/Dockerfile#L1
Use an incorrect copy command syntax copy instead of \copy and cannot quit app after that: ``` Server: PostgreSQL 14.15 Version: 4.3.0 Home: http://pgcli.com simplifi-live> copy (select id from transcoding_formats...
[`mycli`](https://github.com/dbcli/mycli) supports `--init-command` option: ``` --init-command TEXT SQL statement to execute after connecting. ``` - Does `pgcli` have this? - Is it possible to specify the init commands in the...
Whenever I start `pgcli` it seems to start a background python process, that ends up showing up in my dock. It doesn't hurt, it just gets in the way a...
Thank you for storing the config in $XDG_CONFIG_HOME (~/.config/) instead of directly in $HOME. But log and history files should not be stored in the same config directory according to...
The install instructions on https://www.pgcli.com/install don't match the install instructions on this repo's readme. On this repo it lists the dependencies as: ``` sudo apt-get install python-dev libpq-dev libevent-dev ```...
I just upgraded to `4.3.0` version and I get this error: ``` $ pgcli -V Traceback (most recent call last): File "/usr/bin/pgcli", line 5, in from pgcli.main import cli File...
## Description I edited `pgclirc` file and added a new alias_dsn. However, when I run `pgcli --list-dsn` it doesn't return anything. this is from my config file: ``` [alias_dsn] pg...
