Writer Overview
The PostGIS writer module stores both geometry and attributes into an PostgreSQL database. Note that attribute case is preserved, unless the option to lowercase attributes is set to ‘yes’. The PostGIS writer provides the following capabilities:
- Transaction Support: The PostGIS writer provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
- Index Creation: The PostGIS writer can set up and populate indexes as part of the loading process. By default, a GiST index is created on the primary geometry column of a table and not on any other columns. Additional columns can be individually indexed. Composite column indexes are not supported at this time.
- Bulk Loading: By default, the PostGIS writer uses a bulk loading technique to ensure speedy data loading.