pgcli
pgcli copied to clipboard
dbcli
Postgres CLI with autocompletion and syntax highlighting
## Description `pgcli 'user=@something password=xxxxx host=x.x.x.x port=32765 dbname=@something'` user and dbname start with `@` I use this command to connect the database, then it raised `invalid connection option "dsn"`. This...
## Description Summary: Attempting simple query on a foreign server, docs: https://www.postgresql.org/docs/current/catalog-pg-foreign-server.html Detail: I have this schema: ``` my_db> \dn +----------+-------------------+ | Name | Owner | |----------+-------------------| | partman |...
## Description An initial implementation of #1359. If you run `listen channelname` and the channel receives a notification, the next time you run a statement, the notification will be shown...
## Description It'd be nice to be able to view a query result as a 2D table, such as can be done in psql with its `\crosstabview` command. For instance...
## Description When executing an external SQL script via the `\i` command, any comment line (i.e. `--`) causes the query(-ies) not to run. The very same script without comment works...
## Description All backslash commands such as `\?` `\i` stop working when `[F5] Explain` is enabled. It outputs the following error: ``` syntax error at or near "\" LINE 1:...
## Description Unable to quite pgcli if the server has shutdown. I can't seem to exit if I have a running pgcli against a server that has shutdown after I...
## Description Following [PEP 621](https://peps.python.org/pep-0621/), setup.py is soft-deprecated (not truly deprecated but not the way to go anymore) and metadata in pyproject.toml is the new norm. This change should be...
## Description Make F1 key launch man page for current query. E.g. I have `CREATE TABLE foo` as my query and I press `F1`. The man page `CREATE_TABLE` is launched....
## Description Boolean type display error。 ## Your environment When I use pgcli connect to OpenGaussDB，boolean type always show false。 ```sql create table t2(a int,b boolean); insert into t2 values(1,false);...
