how to add a password to a user in postgres code example

Example: create password for user in postgres

ALTER USER davide WITH PASSWORD 'hu8jmn3';