Can a person with a masters in psychology work at a hospital as a social worker?

I am currently a psychology major and I'm debating if I should change to MSW. Which would bring in more money? I want to work in a hospital setting.