Favorite Linux Editor for PostgreSQL Scripts?

I'm still new to the Linux world, and do not have a bias for editor choice.
I have one colleague that uses Emacs, but another is worried it leads to
RSI and carpel tunnel syndrome, because the hands are on the keyboard all
the time.

So what are the favorites for PostgreSQL scripts? I need to start learning
one.

Steve Miller
SIL International