postgres change password from command line code example

Example: create password for user in postgres

ALTER USER davide WITH PASSWORD 'hu8jmn3';