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