yt3, I take offense at your liberal projection onto Jesus as an effete. It shows a very serious disdain for scripture, and the person of Christ. If your going to claim allegiance to Him, at least show Him some respect by learning who He is, and not who you wish He is. If you don't like what you find, don't use Him as part of your passive aggressive manipulation of others. That's the coward's path - I'd hope for more from you.
Since Jesus quoted extensively from the Psalms, and as the son of God is also the author of the work, then yes, to pray the Psalms in Christ's name would always be appropriate. Christ Himself cursed the fig tree, scourged the money changers, and was highly regarded by the liberal intellectual elite of his time as a radical, rough, and a violent threat to their monopoly of power. This same person declared that those who do not own a sword, should sell a cloak and buy one. And went on to say that His return will be with a sword - a time we all, including Obama, should anticipate with fear.
I do not know how Obama stands before God; I can only guess based on his actions and speech. I pray that Obama would repent before God and seek forgiveness and wisdom - he has tremendous responsibility in the position to which he aspires. I say aspires because to this day he feels as though he has to assert his right to be there, and it hampers his ability to simply lead. Perhaps he lacks confidence, perhaps he lacks conviction, perhaps he bears guilt and shame ... again, I'd only be guessing based on the external having no window to his soul. But God to whom my prayers are offered in the name of Jesus Christ, knows his soul, and can just as easily remove him from office as He has countless rulers before Obama. I pray that whatever is best for this country would be done, and if that means Obama is a single term president (shortened days) then so be it. If Obama gets a second term, I will know that God has passed judgment on this country, and turned it over to its own idolatry and selfishness - which you might call the democratic process at its worst.
