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

Ubuntu: ZIP a Folder Recursively ?>

Ubuntu: ZIP a Folder Recursively

Run command sudo apt-get install zip in termintal to install the zip. Then run zip -r compressed_filename.zip foldername command to zip a folder recursively. Reference: http://askubuntu.com/questions/27349/how-do-i-compress-a-directory