For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
| Name | The name of the field to be written. |
| Type |
This format supports the following field types. boolean Represents a Boolean value. byte Represents a fixed-length binary object. char Represents a fixed-length character string. date Represents date data. See Standard FME Date/Time Format. decimal Represents a decimal number with maximum precision of 39. float4 Represents a 32-bit (4-byte) double-precision number. float8 Represents a 64-bit (8-byte) double-precision number. int1 Represents a 8-bit (1-byte) signed integer. int2 Represents a 16-bit (2-Byte) signed integer. int4 Represents a 32-bit (4-byte) signed integer. int8 Represents a 64-bit (8-byte) signed integer. longbyte Represents a Binary Large Object (BLOB). longnvarchar Represents a variable length Unicode Character Large Object (CLOB). longvarchar Represents a variable-length Character Large Object (CLOB). money Represents a number with two decimal places of precision in the range -999,999,999,999.99 to 999,999,999,999.99. nchar Represents a fixed-length Unicode character string. nvarchar Represents a variable-length Unicode character string. time This type is used to represent time data with an accuracy of up to 1 second. See Standard FME Date/Time Format. timestamp This type is used to represent date and time data with an accuracy of up to 1 microsecond. See Standard FME Date/Time Format. timestamptz This type is used to represent date and time data with time zone information and an accuracy of up to 1 microsecond. See Standard FME Date/Time Format. timetz This type is used to represent time data with time zone information with an accuracy of up to 1 second. See Standard FME Date/Time Format. varbyte Represents a variable-length binary object. varchar Represents a variable-length character string. |
| Index |
The types of indexes and constraints to create for the column. Indexes and constraints are created only if the table is created. Each index and constraint contains only one column. The valid values for the column type are listed below: PrimaryKey: Applies primary key constraint. UniqueNotNull: Applies non-nullable and unique constraints NotNull: Applies non-nullable constraint. |