The black pipe usually used for sewerage. If you want to know why I chose ABS, take a chunk of PVC pipe. Hit it with a 25 lb sledge hammer. The sledge hammer bounces off the pipe and smashes into your foot. PVC also gets brittle with exposure to sunlight.
ABS just gets hot.
That's the thick stuff. It costs a little more, but not that much more. The bill of material says 10 foot lengths, only because that's as small a piece as is normally sold. Finding pressure rated ABS pipe is nearly impossible in many areas. Most spud shooters are therefore constructed of PVC pipe.