Release v2.1.0

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.


  • 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)


  • (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)