Local Anesthesia or General Anesthesia

For my first child I was out to sleep during the c-section. I’m wondering would I be able to be out to sleep during this c-section because I refuse to give vaginal birth but I’m also scared to stay awake during the c-section. I don’t want to feel any type of pain.