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 the syntax-highlighting of various Postgres specific keywords and adds the ability to surface messages thrown by sql exceptions.