This can be done via pgAdmin III.
- Open PGAdmin and click on the Spatial Data Warehouse database pgAdmin III and connect to PostgreSQL as an Admin user.
- Click on the node for your Spatial Data Warehouse database (sdw) in the tree view and connect as an Admin user..
- Click on the SQL button
Enter the following command in the SQL Editor.
Code Block ALTER USER "user" WITH PASSWORD 'password';
e.g.
- Click on the green arrow
You should see a message like this in the Output pane (the number of msec may be different).
...