DuckDB User Attributes
Readers: For information on the parameters in this dialog that are common to all readers, see:
User attributes for this format are listed below.
Name |
The name of the field to be written. Valid values for the field name are less than 255 characters, and include any SQL-valid characters. |
Type |
Description |
---|---|
bigint |
An 8-byte signed integer. |
blob |
Variable length binary data. |
boolean |
A single boolean value. |
date |
A calendar date. |
decimal |
A fixed-precision number with a width and scale. |
double |
An 8-byte double precision floating-point number. |
hugeint |
A 16-byte signed integer. |
integer |
An 4-byte signed integer. |
float |
A 4-byte floating point precision number. |
smallint |
A signed 2-byte integer. |
time |
The time of day. |
timetz |
The time of day which includes the timezone. |
timestamp |
A combination of a date and a time. |
timestamptz |
A combination of a date and a time adjusted to the current time zone. |
timestamp_ns |
A timestamp with nanosecond precision. |
timestamp_ms |
A timestamp with millisecond precision. |
timestamp_s |
A timestamp with second precision. |
tinyint |
A signed 1-byte integer. |
ubigint |
An unsigned 8-byte integer. |
uhugeint |
An unsigned 16-byte integer. |
uinteger |
An unsigned 32-bit integer. |
usmallint |
An unsigned 2-byte integer. |
utinyint |
An unsigned 1-byte integer. |
uuid |
A UUID string. |
varchar |
A variable length character string. |