The adapter only helps the cable's plug to fit in wall socket.
And thanks for bringing up this voltage thing.. which i overlooked.I think, A 110v rated US PS3 can work in 230v Indian Environment(correct me if i am wrong). But IF you want to be well secured from all sides.. get a step down transformer. You get get one from 200INR onwards. But purchase a decent quality one. Cheap Transformers will have some thing like 250W capacity. But i think PS3 draws somewhere near 350-400w. So get a decent quality one.You get get a step down transformer from any local electrical appliances shop.
This is where power brick pays off. It takes care of stepping voltage up and down. PS2 had a power brick.. x360 has one too.But There is no power brick for PS3