Cacher is the code snippet organizer for pro developers

psql --version
select version();

ALTER USER 'user_name' WITH PASSWORD 'new_password';

change password for postgres using pgsql

su postgres
psql
\password