Sex after giving birth.

Is it painful to have sex the 6 weeks after giving birth? What does it feel like? What should I expect? weird question.. but i’m curious!