What is the difference between spinal anethesia (for csection) and a lumbar puncture (for CSF testing)? Is one more painful then the other?

No, they are the. same procedure and you are given local anesthesia prior in both. You might be able to receive sedation prior to CSF testing but probably not if pregnent.