I would like to be prescribed to promethazine w/codeine for my allergies, sneezing cough, insomnia, restlessness, agitation, anti-pshychotic effects..

Prescriptions. If you see your physician, s/he will take your history and examine you -- and also order any diagnostic tests that might help diagnose your condition. Sounds like you've been reading up on the possible effects of Promethazine w/codeine -- but your doctor will be the one to determine what, if anything, s/he feels is appropriate to prescribe. Best wishes.