PostGIS Cookbook - Second Edition

Getting ready

pgRouting doesn't deal well with nondefault schemas, so before we begin, we will set the schema in our user preferences using the following command:

ALTER ROLE me SET search_path TO chp06,public;

Next, we need to add the pgrouting extension to our database. If PostGIS is not already installed on the database, we'll need to add it as an extension as well:

CREATE EXTENSION postgis;
CREATE EXTENSION pgrouting;

We will start by loading a test dataset. You can get some really basic sample data from http://docs.pgrouting.org/latest/en/sampledata.html.

This sample data consists of a small grid of streets in which any functions can be run.

Then, run the create table and data insert scripts available at the dataset website. You should ...