Usually you don't teach at where you graduate from, at least not initially. That said, as others have noted, if you want to teach at Columbia or some other big name school as full time faculty, you better be a psychology superstar. The optimal situation would be to find a POI who graduated from Columbia who is now a professor at some other big name school and do your graduate training with them. Hopefully the connections they have to Columbia will set you up later to get into that department at some time in the future.
You would be amazed at the power that a phone call and a letter can have inside a relatively small community like psychology. Good luck, you might want to alter your plan slightly. Rather than pin all your dreams to going to Columbia and teaching at Columbia, perhaps set your sites on the top tier schools (this will be a challenge in itself.) You would be amazed to understand how competitive things really are in just getting in to graduate school much less becoming a professor.
I read some of your other posts, if you believe:
"medical school > pharmacy or getting a phd in psych or dental>>pa" <- You are in for a RUDE awakening.
and
"what health care field would you think this type of personality is best for..
i am over confident
i think and like to be right all the time
im both lazy and able, i got capability and i got laziness
and i like the humanities and philosophizing about endless and mundane things even if stupid."
I think you might want to consider something along the lines of physics.
Finally, it sounds like you are really unsure where you want to be:
"i did want to go into psychiatry...
but..
i found the field of working with mentally crazy people slightly..
too interesting..
regardless..
if anything i'd be like the dude on law and order svu who works with the legal system and works as a psychiatrist"
You have time to think this through, so take the time.
"eh.. i mean.. psychiatry is all about talking.. thinking.. and prescribing drugs..
there's no real prevention or actual fixing.. just treat and keep the person stable..
its depressing .."
Wow, I know some psychiatrists who would be pretty offended by that statement. For that matter, Psychologists often help keep people with personality disorders stable with no "actual fixing" or "prevention", and personally, I enjoy working with people with personality disorders.
Mark
PS - Some asked why "crisis question", I think it's because he doesn't know what he wants to do, hence the crisis.