Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

  1. Open PGAdmin and click on the Spatial Data Warehouse database 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 and connect as an Admin user..
    Image Added 
  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).

...