If you're a programmer and you don't use Vim, I hope, for your sake, it's because you use Emacs. ;-)
(Though, I must say, my jobs usually require me to hack a lot of Java, and I have taken quite a liking to Eclipse.)
If you use a programmer-oriented text editor every day for years, it becomes more than a tool, and rather an extention of yourself: you customise it to fit your needs. Here are some of my customisations:
PostgreSQL Vim Syntax File
Looking for PostgreSQL syntax highlighting in Vim?
I originally copied the Vim distribution's supplied sql.vim to postgresql.vim and edited that. But, then I found Devrim Gunduz'spgsql.vim, edited that to my liking, and e-mailed him my changes. Download my edited version.
If you use Fedora, postgresql.vim will go in /usr/share/vim/vim71/syntax, and you will also want to add, to the appropriate place in /usr/share/vim/vim71/filetype.vim, the following lines:
" PostgreSQL au BufNewFile,BufRead *.pgsql setf pgsql
(I put mine right after the Postfix entry, respecting the alphabetical order of the entries.)
Vim RC Files
These are the files I use for vi and vim. I've renamed them without the leading dot and with a .txt extension just so they'll be associated with a text/plain MIME type if you decide to download them.