Interestingly, plumbing your house with PVC water pipe is not a fantastic idea and is not allowed under most plumbing codes. The specific issue is that PVC loses strength at higher temperatures, so performance at household water pressures with household hot water is somewhat marginal. Manufacturers don’t rate their pipe at all above 140 degrees F. Having your pipe burst when you run hot water through it is undesirabl…
Most indoor water pipes are still copper but PEX is becoming more popular. Outdoor is now nearly always MDPE.