I didn’t learn this until recently but in psql you can use \e or \editor to open the current line in $EDITOR. It helps a lot.