How bad does the epidural hurt?

Going in for my scheduled c section in 4 weeks and I’m over the moon to finally hold my baby girl but the one thing that has my nerves going crazy is the epidural I’m a ftm and don’t know what to expect and just wondering does it really hurt as bad as people say?