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 version adds more color schemes to the syntax highlighting. An attempt to add support for PyPy ...
read more