pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.