PostgreSQL Cheat Sheet/Change role password

Update a role password.

Section: Database and Role Lifecycle

Change role password

sql
sql
ALTER ROLE appuser WITH PASSWORD 'new-secret';
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Database and Role Lifecycle
Create login role
Create a role that can log in.
OpenIn sheetsqlsame section
Create role with privileges
Create a role with explicit capability flags.
OpenIn sheetsqlsame section
Drop role
Remove a role from the cluster.
OpenIn sheetsqlsame section
Grant role membership
Add a role as a member of another role.
OpenIn sheetsqlsame section
Revoke role membership
Remove inherited privileges from a member role.
OpenIn sheetsqlsame section
Create database
Create a new database in the cluster.
OpenIn sheetsqlsame section