My personal favorite psql command: \e, which is used to edit the query currently being written or the last query run in your preferred editor.