Pgcli was launched today on HackerNews and Reddit.

Pgcli is a command line interface for Postgres database that can do auto-completion and syntax-highlighting among other things. A list of features with screenshots are available on the features page.

Source is available on github: http://github.com/amjith/pgcli