Table of Contents

pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

This is the manual for pgRouting 2.1.0 (b38118a master).

Creative Commons Attribution-Share Alike 3.0 License

The pgRouting Manual is licensed under a Creative Commons Attribution-Share Alike 3.0 License. Feel free to use this material any way you like, but we ask that you attribute credit to the pgRouting Project and wherever possible, a link back to For other licenses used in pgRouting see the License page.



For a more complete introduction how to build a routing application read the pgRouting Workshop.


pgr_version - to get pgRouting’s version information.

Data Types

pgRouting Data Types

  • pgr_costResult[] - A set of records to describe a path result with cost attribute.
  • pgr_costResult3[] - A set of records to describe a path result with cost attribute.
  • pgr_geomResult - A set of records to describe a path result with geometry attribute.

Topology functions

Topology Functions

Routing functions

Routing Functions

Pre processing or post processing helping functions

Driving Distance post-processing

Experimental and Proposed functions

This section contains new experimental or proposed signatures for any of the following sections:
  • topology functions
  • routing functions
  • vehicle routing functions
  • pre / post procesing helper functions

We are including them so that the pgRouting community can evaluate them before including them as an official function of pgRouting.

Some of them are unsupported like the GSoC functions.

Experimental functions: Proposed by Steve Woodbridge

Convenience Functions

Experimental functions: by GSoC

The following functions are experimental
  • They may lack documentation,
  • Were created by GSoC students.
  • they are unsupported.

Proposed functions: Proposed by Zia Mohammed

About this proposal:
  • Author: Zia Mohammed.
  • Status: Needs a lot of testing. I am working on that.
  • I did not add automated test.
  • Temporary name: pgr_labelGraph
  • Need: I need feedback from the community.
  • pgr_labelGraph - Analyze / label subgraphs within a network

Discontinued Functions


Developers’s Functions


In V3.0 This function are going to be discontinued. Use the already available underscored version instead.


Developers’s Functions documentation is going to be deleted from the pgRouting documentation in V3.0

The following functions are used internaly the topology functions.

Release Notes

Indices and tables