Introduction

Several Python <=> PostgreSQL adapters are available that allow direct access to PostGIS spatial data types inside the PostgreSQL database.

Details

Using Python within PostgreSQL

• The pg/python project
• The PL/Python procedural language for functions in Python

Connecting to PostgreSQL with Python

• Tutorial Examples using Psycopg2:
• Josh Drake's article "Accessing PostgreSQL with Python and Psycopg2"
• Al Lukaszewski's article "Reading from a PostgreSQL Database With Python"
• Tutorial Examples using PyGreSQL pgdb driver
• Anyone use this driver?

Examples

Basic Usage

To do

Advanced Examples

• AsKML_Python_Advanced_Example