So tempted to go and buy a magnet and copper pipe now!
I guess I have to buy a copper tube to find out.
Some commercial products were Magview, Magcheck, Ferro-see, and Sprague-Mag. I don't know if any of these are still available.
The spray is iron powder suspended in a fluid (like trichlorotrifluoroethane) that evaporates rapidly and leaves magnetic particles oriented according to the magnetic field. The pattern can be made permanent by spraying with a fixative or hairspray, or lifted with cellophane tape.