From my experience, if you're a danger to yourself or others, that's when they keep you. I've never seen a psychiatrist in the ER, but the attending physician or social worker will try and find a bed for you in that hospital's psych ward or a nearby hospital, depending on your doctor or insurance.