The directives that are processed by the PostGIS Raster writer are listed below. The suffixes shown are prefixed by the current <WriterKeyword>_ in a mapping file. By default, the <WriterKeyword> for the PostGIS raster writer is POSTGIS_RASTER_OUT.
DATASET/DATABASE, HOST, PORT, USER_NAME, PASSWORD
These directives operate in the same manner as they do for the PostGIS raster reader.
START_TRANSACTION
This statement tells the PostGIS raster writer module when to start actually writing features into the database.
The PostGIS raster writer does not write any features until the feature number of features are skipped, and then it begins writing the following features. Normally, the value specified is zero – a non-zero value is only specified when a data load operation is being resumed after failing partway through.
Required/Optional
Optional
Mapping File Syntax
POSTGIS_RASTER_OUT_START_TRANSACTION 0
Workbench Parameter
Starting Feature
TRANSACTION_INTERVAL
This directive determines the number of features that FME will place in each transaction before a transaction is committed to the database.
If the POSTGIS_RASTER_OUT_TRANSACTION_INTERVAL statement is not specified, then a value of 1000 is used as the transaction interval.
Required/Optional
Optional
Mapping File Syntax
POSTGIS_RASTER_OUT_TRANSACTION_INTERVAL 2000
Workbench Parameter: Features Per Transaction
BULK_COPY
This statement tells the PostGIS raster writer module to insert data into the database using either SQL INSERT statements or the SQL COPY command. The default option is the bulk copy using the COPY command, which yields the best performance.
Required/Optional
Optional
Mapping File Syntax
POSTGIS_RASTER_OUT_BULK_COPY YES
Note: The bulk delimiter escaping has improved, and therefore it is no longer necessary as a backup measure. However, if individual inserts are desired, this option can be set to NO.
Workbench Parameter
Bulk Insert
SPATIAL_COLUMN_NAME
The default value of rast creates a spatial column with the name “rast” on the destination tables by default. This value can also be set specifically for individual feature types.
Note: This directive only applies at the time of workspace or mapping file generation.