How to Change User Password in PostgreSQL Quickly

To change a user password in PostgreSQL, use the ALTER USER username WITH PASSWORD 'new_password'; command. This updates the password immediately for the specified user.

Syntax

The basic syntax to change a user's password in PostgreSQL is:

• ALTER USER: Command to modify a database user.
• username: The name of the user whose password you want to change.
• WITH PASSWORD 'new_password': Sets the new password for the user.
• End the command with a semicolon ;.

sql

ALTER USER username WITH PASSWORD 'new_password';

Example

This example changes the password for user alice to secure123. You must run this command as a superuser or the user itself.

sql

ALTER USER alice WITH PASSWORD 'secure123';

Output

ALTER ROLE

Common Pitfalls

Common mistakes when changing passwords include:

• Not having sufficient privileges to run ALTER USER.
• Forgetting to use single quotes around the new password.
• Trying to change password for a user that does not exist.
• Not ending the command with a semicolon.

Always verify the username and your permissions before running the command.

sql

/* Wrong: Missing quotes around password */
ALTER USER alice WITH PASSWORD secure123;

/* Correct: Quotes included */
ALTER USER alice WITH PASSWORD 'secure123';

Quick Reference

Command Part	Description
ALTER USER	Modify an existing database user
username	The user whose password you want to change
WITH PASSWORD 'new_password'	Set the new password (must be in single quotes)
;	End of SQL command

Key Takeaways

Use ALTER USER username WITH PASSWORD 'new_password'; to change passwords.

You need superuser rights or ownership to change another user's password.

Always enclose the new password in single quotes.

Check that the user exists before running the command.

End your SQL command with a semicolon to execute it properly.