row/cell editing tool

while I can use psql/pgcli for almost all my needs, there's one I fall short on that requires me to open a gui for - editing a cell.
suppose a particular column is a text one and it holds a long string which I wish to edit.
currently I only can issue an `UPDATE TABLE ... SET ...=...` command to it.
I really wish there was some way to edit a cell in my favorite text editor the same way `\e` does.

I'm not yet sure how the syntax should look but a tool that could give me that would be really awesome