TIL. I use pgcli daily and it's truly awesome software. My favorite trick is the old Ctrl-X Ctrl-E to edit the query on VIM.