This can be done via pgAdmin III.
Enter the following command in the SQL Editor.
ALTER USER "user" WITH PASSWORD 'password';
e.g.