I don't scar well, so 7 1/2 years on it's still pretty obvious. But it's raised and white (same colour as the rat of my belly), so not overly unattractive. Not that anyone is looking at it (I can't even see it under the belly atm!).
I never had any issues under the skin, with muscles, numbness, etc. it healed well and quickly. But since there are variations in technique from ob to ob (and c/s to c/s, depending on the mum and the situation), it's quite hard to tell what you can expect. I also did a postnatal class for at least six mths afterwards, which worked on strengthening the core muscles that would have been affected by pg and the c/s.
Bookmarks