I recently discovered pgcli, it is pretty slick