In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script.
1  | ALTER user xuser with password 'Asdf1234';  | 
 
If you want to change your own password, you can change your password using the following command after connecting to PostgreSQL.
1  | \password  | 
 ![]()
Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 