PostGIS Cookbook - Second Edition

How it works...

In this recipe, we created a new database and installed PostGIS in its own schema. We kept the PostGIS objects separate from our geometries and rasters without installing PostGIS in the public schema. This separation keeps the public schema tidy and reduces the accidental modification or deletion of the PostGIS objects. If the definition of the search path did not work, then use the explicit definition of the schema in all the commands, as shown.

In the following recipes, we will see that our decision to install PostGIS in its own schema results in fewer problems when maintaining the database.