About User Attributes
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. 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. 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. 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). timestamptz
Represents complete time stamp values that include the date, the time of day, and a time zone. 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). 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. So a VARCHAR(120) column consists of a maximum of
The maximum length is 65535 bytes (64K – 1). VARCHAR values are not padded with spaces. |