- PgAdmin, open up the SQL window by clicking the SQL button (the one with the pencil).
-
Choose “File ? Open…” and navigate to
C:\Program Files\PostgreSQL\8.3\share\contrib\lwpostgis.sql
-
Press the “Run” button. (The green triangle.) The lwpostgis.sql file will execute, loading the PostGIS functions and objects into the “postgis” database.
-
Choose “File ? Open…” and navigate to
C:\Program Files\PostgreSQL\8.3\share\contrib\spatial_ref_sys.sql