If you find that you do like using vi editing mode (and what's not to love about it :), add 'set editing-mode vi' to your .inputrc, and vi mode will work in any readline based client, eg psql, irb.
via Daily Vim: Text Editor Tips, Tricks, Tutorials, and HOWTOs: Vi Mode in Readline…