PostgreSQL Feature Representation

Features read from PostgreSQL consist of a series of attribute values only and no geometry. The feature type of each feature is as defined in the feature type parameters, but the only type used is postgis_none. Underlying PostgreSQL geometries are not read as geometries but are interpreted as strings.

Features written to the database have the destination table as their feature type, and attributes as defined in the feature type parameters.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type Attributes), this format adds the format-specific attributes described in this topic.

Attribute Name

Contents

postgres_type

The type of geometric entity stored within the feature. The valid values for the object model are listed below:

postgres_none

Features read from, or written to, PostgreSQL have an attribute for each column in the database table. The feature attribute name will be the same as the source or destination column name. The attribute and column names are case-sensitive.

No Coordinates

postgres_type: postgres_none

Features with no coordinates are tagged with this value when reading or writing to or from PostgreSQL. This is the default.