I have tried JB Weld products, epoxy, water epoxy, and water tape. I do not want to replace the pipe--just fix it for now. The pipe is a cold water supply.
Your best bet to fix the leak is to turn off the water, drain the line, and then cut out the bad section and replace with some new glued in fittings and pipe pieces.
This question comes up in the first page on Google and there's no mention of a Sharkbite, so I thought I would necro-answer. Sharkbites are compression fittings available at Home Depot. They function similar to a repair clamp, but they seem like they seal better to me. They're very easy to install, as well.
Pipe Repair Clamp
There are quite a few different styles; however, almost all of them are designed for metal pipes. Personally, with PVC I still suggest replace a section of the pipe, but if you can't this will get by in a pinch.
Make sure to prepare the surface. Turn the water supply off, sand the area (get rid of your epoxies and rough up the surface). For a good seal, I'd add some 100% silicone "caulking". then put the clamp on. The clamps come with a rubber gasket and if you are using a universal size one then be extra careful not to crack the pipe, it takes a bit but is surprisingly easy when using tools. Allow a couple of hours for the silicone to dry (most dry times listed are expecting surface air to help dry/cure it so if you can manage it leave it overnight)
Bondo fiberglass resin, while a little messy, worked to patch a leaking PVC sump pump pipe joint. The pipe location was in a tight spot making cutting it out a much bigger pain. Two other products that are less messy (than fiberglass) and might do the job -- Fiber Fix and Perma-Wrap.
Watts quick connect. Simply cut out section where the pinhole is and stab the pipe into the quick connect. Easy as 123. I've even done this with copper and it works great. No more soldering or worrying if the water is out of the pipe. You will not regret it!
I had a puncture happen in an area that cutting the pipe and adding a coupling was going to be a super mission. What I ended up doing was cutting a coupling in half (so you get 2 u shaped pieces), gluing it on, and using a hose clamp to tighten it. This was for a sprinkler pipe so not nearly as much constant pressure as a house pipe but it's been holding for weeks now.
By using a Ice Maker self tapping shut off you can place the the nail of the shut off in the pinhole and screw clamp down
Sombody went through a wall in my rv with a finishing with a finishing nail. The pipe it punctured was a 1" long 1/2" pipe, In such a tight spot I couldn't use a saw, almost got a small cut off wheel, but instead used a ratcheting pvc cutter (looks like scissors or pruners, $12 at home depot) cut the pipe near the hole. Used Oatey brand "handy pack" which contains purple primer and medium orange cpvc cement, and used it to "weld" on a $.73 coupler fitting. This will be a permanent fix. Also I installed this on a water line for the inside/outside showers, toilet, and bathroom sink. Not drinking water so I didn't even ask if it was drinking water safe! I'm sure it would be fine after thoroughly running water or if you have a high grade water filter.