Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: 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. Valid values for column name include any character string devoid of SQL offensive characters and less than 32 characters in length. |
| 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. Range: 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. Range: -32768 to +32767. int4 Represents a signed 4-byte integer. Range: -2147483648 to +2147483647. int8 Represents a signed 8-byte integer. Range: -9223372036854775808 to +9223372036854775807. numeric Stores values with a user-defined precision, up to 128 bits and 38 digits of precision. timestamp Represents a complete timestamp value that includes the date and the time of day. The values are UTC, not local time. Range: 4173 BC to 294276 AD with a resolution of 1 microsecond (up to a maximum of 6 digits of precision for fractional seconds). timestamptz Represents complete time stamp values that include the date, the time of day, and a time zone. Range:4173 BC to 294276 AD with a resolution of 1 microsecond (up to a maximum of 6 digits of precision for fractional seconds). The time zone is converted and stored as a Coordinated Universal Time (UTC) value. varchar Represents a variable-length character string with a user-defined limit. This type supports UTF-8 multibyte characters up to a maximum of 4bytes. Therefore, a VARCHAR(120) column consists of a maximum of:
The maximum length is 65535 bytes (64K – 1). VARCHAR values are not padded with spaces. |