Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using:
$ pip install -U pgcli
This pgcli release has only one feature in it: migration to Python Prompt Toolkit 2.0. The migration was non-trivial, because prompt-toolkit was reworked almost from the ground up, and 2.0 is not compatible with 1.x. But now, pgcli can finally use those exciting new features that prompt-toolkit 2.0 has.
Many thanks to Jonathan Slenders and Dick Marinus, who worked hard on the migration!
Things to be aware of
- mycli did not yet migrate to prompt-toolkit 2.0. Until it does, pgcli and mycli can't be installed into the same venv.
- Same goes for ipython. It already migrated, but is not yet released. To install ipython into the same venv as pgcli, you'll have to do it from master:
$ pip install pip install git+https://github.com/ipython/ipython.git
As always, we are here to help in case of any issues with the new release: