The space character's name is The Great Gazoo and he is from the planet Zatox.
Yeah his name was the Great Gazoo dumb dumb...lol. That's what he used to say to Fred.
I thought it was the Great Kazoo...one or the other. Double check by finding The 2nd Flintstones movie, Viva Rock Vegas..the live action one which..(I'm pretty sure it's Kazoo) is in.