Water Torture?

Growing up, we would teach our cats/dogs to get off the furniture by shooting them with a water gun. Do you think it will work with my kiddo?