The dbcli suite (pgcli, mycli) provide a great user experience on the command line that even some gui database tools don't match up to.

https://github.com/dbcli