database | Database in which the username is defined (this can be a database name or a server DSN) |
username | The user whose password will be changed. |
password | The current password for the user. You must provide the original password in order to modify it. You can either provide the password as a parameter or omit it and be prompted. |
newpassword | The new password for the user. See
Identifier Restrictions by Identifier Type in Advanced Operations Guide for password restrictions. Note: If the new password begins with a nonalphabetic character, the password must be enclosed in single quotes. If the existing password begins with a non-alphabetic character, do not enclose it in single quotes (see examples). |
-server name | Optional. Server name on which the database is defined. If you do not specify this option, the local machine is assumed |
-port number | Optional. TCP port on which the SQL engine running on servername is listening. If you do not specify this option, the default port 1583 is assumed. See also
Changing the Default Communication Ports in Getting Started with PSQL. |