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.