I can't figure out how to get it configured as a pager (in postgres). I've been using pspg set in my .psqlrc.

I changed it to \setenv PAGER 'vd' and I just get a big chunk of text with no ability to navigate columns. How are you doing it with mysql?