Create a world and uncheck the Online game checkbox. Then, start the game. With the second controller, the other player should be able to sign in using another account on the PS3.
The WikiThe Wiki shows how to do this (for the Xbox 360, though the process should be the same for PS3).
Note you need to be on a 720p resolution or be using an HDMI cable.