psql - prompt for password

Hi,

Is createuser the only one I can use to create a user where it prompts for a password? There is no alteruser though.

I want to use psql and \prompt but am lost on how to use it.

Basically just want to use it for running a psql script like for example - ALTER USER spongebob WITH ENCRYPTED PASSWORD ':newpassword';

Regards,

Ed