pgcli
pgcli copied to clipboard
dbcli
Postgres CLI with autocompletion and syntax highlighting
## Description I've installed extension _PostGIS_, but cannot autocomplete its functions. Is this possible at all? ## Your environment ### pgcli --version `Version: 3.0.0` - build bcb0c8bce776a5eba9f5425c57c2ec8385f10e94 ### system ```Debian...
The dbcli projects all use the the `prompt_toolkit` module, as do other popular packages like ipython. This module exposes a lot of possiblities to configure prompts, the majority of which...
## Description When I tried to use the native command ```\! clear``` to clear screen it didn't work with pgcli as it works in psql ``` $ pgcli Server: PostgreSQL...
## Description Pressed `r` to replace a single character in vi mode, got this: ``` Unhandled exception in event loop: File "/usr/lib/python3.8/asyncio/events.py", line 81, in _run self._context.run(self._callback, *self._args) File "/home/jo/.venvs/au/lib/python3.8/site-packages/prompt_toolkit/eventloop/utils.py",...
## Description Setting intervalstyle to `postgres_verbose` gives incoherent results, and sometimes an error. example: ```sql psql> set intervalstyle = 'postgres'; SET Time: 0.001s psql> select now() - now() ; ╒════════════╕...
## Description It will be useful to be able to highlight hostnames based on some criteria to be able to discern production hosts from regular hosts. In our deployment, all...
Now that the indentation within EXPLAIN was fixed, perhaps it'd be a good idea to make it more readable than in original PostgreSQL? Color highlighting would imho be a good...
ConfigObj fixes a lot of problems with INI, which isn't a real format, but AFAIK is a dead end in terms of adoption and indeed wider recognition as it's just...
## Description Named queries is very convenient when using pgcli, but I notice that there's a little difference between named query and normal query. The result of named query comes...
In my psqlrc file, I have the following: \set HISTFILE ~/.psql_history- :DBNAME This allows for a history file per database I connect to, making it easy to get the history...
