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 version comes with quite a few fixes and a couple of nice usability improvements, including automatic reconnect.
Features:
- Keybindings for closing the autocomplete list. (Thanks: easteregg)
- Reconnect automatically when server closes connection. (Thanks: Scott Brenstuhl)
Bug fixes:
- Avoid error message on the server side if hstore extension is not installed in the current database (#991). (Thanks: Marcin Cieślak)
- All pexpect submodules have been moved into the pexpect package as of version 3.0. Use pexpect.TIMEOUT (Thanks: Marcin Cieślak)
- Resizing pgcli terminal kills the connection to postgres in python 2.7 (Thanks: Amjith Ramanujam)
- Fix crash retrieving server version with --single-connection. (Thanks: Irina Truong)
- Cannot quit application without reconnecting to database (#1014). (Thanks: Irina Truong)
- Password authentication failed for user "postgres" when using non-default password (#1020). (Thanks: Irina Truong)
Internal:
- (Fixup) Clean up and add behave logging. (Thanks: Marcin Cieślak, Dick Marinus)
- Override VISUAL environment variable for behave tests. (Thanks: Marcin Cieślak)
- Remove build dir before running sdist, remove stray files from wheel distribution. (Thanks: Dick Marinus)
- Fix unit tests, unhashable formatted text since new python prompttoolkit version. (Thanks: Dick Marinus)