Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:
$ pip install -U pgcli
Check detailed instructions if you're having difficulty.
This is a minor bug-fix release that fixes unicode issues with hstore.
Bug Fixes:
- Fix unicode issues with hstore. Previously the unicode type caster for hstore was done via a hardcoded oid. This is wrong since the oid for hstore will vary between different databases. Now the oid is determined at the time of connection and a type caster is registered accordingly.
- Fix an error when database is changed using \c.