What it is according to Wiki
“A Foley catheter (named for its designer, Frederic Foley) is a flexible tube that is passed through the urethra and into the bladder to drain urine.”
Why you Would need one
When you can’t urinate on your own because you’re in the hospital for some other complication. Very common.
What it’s really like
“Basically, we clean your man- or woman-junk with Betadine. Afterwards, the doctors bring out the foley catheter, which is this very long soft tube. They put some KY jelly on the tip and then insert it into the urethra of your private parts. We slide it in very deep to make sure it’s at the area of the bladder… It is a very long tube. Sedation is not necessary for this so you can be awake for it.” AE, 4th year Med