how to change user password postgres code example
Example 1: create password for user in postgres
ALTER USER davide WITH PASSWORD 'hu8jmn3';
Example 2: reset password postgres ubuntu
\password sde
ALTER USER davide WITH PASSWORD 'hu8jmn3';
\password sde