Why is copper used to make water pipes rather than magnesium?

copper doesn't rust while iron in an all water environments will form ironoxide (rust) in a very short period of time thus creating the need for something that has similer characteristics but won't rust i.e. copper, it is also cheaper.