Browsed by
Month: November 2013

PostGIS Enabled Schema with Different Schema Name

PostGIS Enabled Schema with Different Schema Name

PLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas Open up SQL Editor Open & execute public_schema.sql Open & execute public_data.sql Open rename_schema.sql and replace `new_schema_name` with the name you want, then execute the query Files can be found here: PostGIS Enabled Schema