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. bigint Represents an 64-bit (8-byte) signed integer. blob Represents a variable length Binary Large Object (BLOB). byte Represents a fixed-length binary object. byteint Represents a 8-bit (1-byte) signed integer. char Represents a fixed length character string. clob Represents a variable length Character Large Object (CLOB). date Represents date data from January 1, 0001 to December 31, 9999. See Standard FME Date and Time Format. decimal Represents a decimal number with maximum precision of 38. float Represents a 64-bit double-precision number. int Represents a 32-bit (4-byte) signed integer. json Represents a variable length JavaScript Object Notation (JSON). number Represents a fixed or floating point decimal. smallint Represents a 16-bit (2-Byte) signed integer. time This type is used to represent time data with an accuracy of up to 1 microsecond. See Standard FME Date and Time Format. timestamp This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with an accuracy of up to 1 microsecond. See Standard FME Date and Time Format. timestamptz This type is used to represent time data with time zone information and an accuracy of up to 1 microsecond. See Standard FME Date and Time Format. timetz This type is used to represent date and time data with time zone information from January 1, 0001 to December 31, 9999 with an accuracy of up to 1 microsecond. See Standard FME Date and Time Format. varbyte Represents a variable length binary object. varchar Represents a variable length character string of length 0 to n. xml Represents XML documents and fragments. |
| 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: PrimaryIndex: Applies primary index constraint. PrimaryIndexNotNull: Applies primary index and non-nullable constraints. PrimaryKeyNotNull: Applies non-nullable and unique constraints on a column that is used as a primary key for the table. Only one primary key is allowed per table. UniqueNotNull: Applies non-nullable and unique constraints. NotNull: Applies non-nullable constraint. |