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 column to be written. |
| Type |
The type of a column in a table. The valid values for the column type are listed below:  bool
Represents logical Boolean values (true/false). char
Represents a fixed-length character string of a specified length, including trailing blanks (if any). The maximum length is 4096 bytes. These strings are always padded with spaces, so a CHAR(10) column always occupies 10 bytes of storage. date
Represents a calendar date (year, month, day). Use this type to store simple calendar dates without timestamps. It ranges from 4713 BC to 294276 AD with a resolution of 1 day. float4
Represents a single-precision floating-point number. This is an inexact storage type, meaning that values are stored as approximations and may result in slight discrepancies. It has up to 6 significant digits of precision. float8
Represents a double-precision floating-point number. This is an inexact storage type, meaning that values are stored as approximations and may result in slight discrepancies. It has up to 15 significant digits of precision. int2
Represents a signed 2-byte integer. It ranges from -32768 to +32767. int4
Represents a signed 4-byte integer. It ranges from -2147483648 to +2147483647. int8
Represents a signed 8-byte integer. It ranges from -9223372036854775808 to +9223372036854775807. timestamp
Represents a complete timestamp value that includes the date and the time of day. The values are UTC, not local time. It ranges from 4173 BC to 294276 AD with a resolution of 1 microsecond (up to a maximum of 6 digits of precision for fractional seconds). varchar
Represents a variable-length character string with a user-defined limit. This type supports UTF-8 multibyte characters up to a maximum of four bytes. So a VARCHAR(120) column consists of a maximum of 120 single-byte characters, 60 two-byte characters, 40 three-byte characters or 30 four-byte characters. The maximum length is 65535 bytes (64K – 1). VARCHAR values are not padded with spaces. |