Pervasive PSQL Writer: Feature Type Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, including the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
Table
- INHERIT_FROM_WRITER (default): Takes the value from the writer level and does not override it at the feature type level.
- INSERT: Allows for only INSERT operations.
- UPDATE and DELETE: These writer modes can be overwritten at the feature type levels.
This is a comma-separated list of the columns that are matched against the corresponding FME attribute values to specify which rows are to be updated or deleted when the writer mode is either UPDATE or INSERT.
For example, NAME,CAPITAL would instruct the writer to ensure that the corresponding FME attributes are always matched against the column with the same name.
Truncate/Drop
If the table exists by this name, it should be truncated before any features are written to it.
If the table exists by this name, it should be dropped and recreated before any features are written to it.