Encoding Issue Exporting from PostgreSQL

I've got a query I'm running and exporting the data from PostgreSQL. I'm ending up with a ton of  characters in place of apostrophes and such when I open it in Wordpad or Excel. Quite frankly, I can't get my ahead around any of this encoding crap. How when I'm ex开发者_JAVA技巧porting the data do I get those characters to show right?

I followed the instructions here and it did it. Thanks everyone anyway.

http://www.wohill.com/a-workaround-for-encoding-problems-in-excel/