O'Reilly logo

PostGIS Cookbook by Bborie Park, Stephen Vincent Mather, Thomas J. Kraft, Paolo Corti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Organizing the database

One of the most important things to consider when creating and using a database is how to organize the data. The layout of the database should be decided when you first establish the database. The layout can be decided or changed at a later date, but this is almost guaranteed to be a tedious, if not difficult, task. If it is never decided, a database will become disorganized over time and introduce significant hurdles when upgrading components or running backups.

By default, a new PostgreSQL database has only one schema, that is, public. Most users place all the data (their own and third-party modules such as PostGIS) in the public schema. Doing so mixes information of different origins. An easy method to separate the information ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required