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 release comes with the ability to save favorite queries, fuzzy matching in auto-completion, new special commands ...
read more