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. |