Creating a View in a Corporate Schema v2.0

This can be done by an admin user via pgAdmin III.

1. Open pgAdmin III and connect to PostgreSQL as an Admin user.
   
   
2. Click on the node for your Spatial Data Warehouse database (sdw) in the tree view.
    

3. Click on the SQL button  and launch the query window.
   
   

4. Enter the CREATE VIEW statement into the SQL editor (you could use the Graphical Query Builder if you prefer).
    
    
5. Click on the green arrow 
   You should see a message like this in the Output pane (the number of msec may be different).