A gunman who killed nine people during a shooting spree at a Charleston church should get the death penalty, South Carolina governor Nikki Haley has said.