\password [ USER ]

\password starts the password change process. Users can only change their own passwords. The command prompts the user for the old password, a new password, and then the new password again to confirm.

A superuser can change the password of another user by supplying the username. A superuser is not prompted for the old password, either when changing his or her own password, or when changing another user's password.

Note: If you want to cancel the password change process, press ENTER until you return the to vsql prompt.