Hi Sheba ~
I also had a C-sec because of a breech bub, I don't remember the needle hurting at all & I have a very low threshold for pain.
They usually give you a needle first that numbs the area, that needle feels like a burning bee sting but it's very bareable! & then the big needle feels like you're being pinched. It's really nothing to be concerened about, I had a really hot orderly who's hand i almost bit off because i was so scared - but it wasn't as bad as i imagined at all.