You are here: FME Readers and Writers > PostGIS Reader/Writer

PostGIS Reader/Writer

Licensing options for this format begin with FME Professional Edition.

Overview

PostGIS is a geometric layer over a PostgreSQL Object-Relational Database Management System (ORDBMS) that provides geometry and Spatial Reference System (SRS) handling. The PostGIS reader/writer module enables FME to read geometric PostGIS data as well as underlying attribute data stored in PostgreSQL.

The PostGIS reader/writer is specifically designed to handle the geometric and SRS portions of the data. When reading attribute-only tables from PostgreSQL, the PostgreSQL reader/writer should be used instead. The PostGIS reader/writer communicates directly with the PostgreSQL libpq interface for maximum throughput.

This chapter assumes familiarity with PostGIS and PostgreSQL, the attribute and geometry types supported, and its indexing mechanisms.

For more information, please see the PostgreSQL home at

http://www.postgresql.org/

and the PostGIS home at

http://postgis.refractions.net/