This can be done by an admin user 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 and launch the query window.
- Enter the CREATE VIEW statement into the SQL editor (you could use the Graphical Query Builder if you prefer).
- Click on the green arrow
You should see a message like this in the Output pane (the number of msec may be different).
...