dropdb geo-demo16 -U postgres
createdb geo-demo16 -E SQL_ASCII -T template0 -U postgres
createlang plpgsql geo-demo16 -U postgres
psql -d geo-demo16 -U postgres -f "C:\Program Files\PostgreSQL\8.2\share\contrib\lwpostgis.sql"
psql -d geo-demo16 -U postgres -f "C:\Program Files\PostgreSQL\8.2\share\contrib\spatial_ref_sys.sql"
psql -d geo-demo16 -U postgres < more_srid.sql
psql -d geo-demo16 -U postgres < geo-demo16.sql
pg_dump -d geo-demo16 -U postgres > geo-demo16-windows-psql82.sql
pause