API for duckdb
DBI Package for the DuckDB Database Management System

Global functions
.onLoad Source code
adbc_connection_init.duckdb_database_adbc Source code
adbc_database_init.duckdb_driver_adbc Source code
adbc_statement_init.duckdb_connection_adbc Source code
arg_match Source code
as.data.frame.duckdb_relation Source code
check_dots_empty0 Source code
check_flag Source code
check_tz Source code
cleanup_user_directory Source code
dbAppendTable,duckdb_connection-method Man page
dbAppendTable__duckdb_connection Man page Source code
dbBegin,duckdb_connection-method Man page
dbBegin__duckdb_connection Man page Source code
dbBind,duckdb_result-method Man page
dbBind,duckdb_result_arrow-method Man page
dbBindArrow,duckdb_result_arrow-method Man page
dbBindArrow__duckdb_result_arrow Man page Source code
dbBind__duckdb_result Man page Source code
dbBind__duckdb_result_arrow Man page Source code
dbClearResult,duckdb_result-method Man page
dbClearResult,duckdb_result_arrow-method Man page
dbClearResult__duckdb_result Man page Source code
dbClearResult__duckdb_result_arrow Man page Source code
dbColumnInfo,duckdb_result-method Man page
dbColumnInfo,duckdb_result_arrow-method Man page
dbColumnInfo__duckdb_result Man page Source code
dbColumnInfo__duckdb_result_arrow Man page Source code
dbCommit,duckdb_connection-method Man page
dbCommit__duckdb_connection Man page Source code
dbConnect,duckdb_driver-method Man page
dbConnect__duckdb_driver Man page Source code
dbDataType,duckdb_connection-method Man page
dbDataType,duckdb_driver-method Man page
dbDataType__duckdb_connection Man page Source code
dbDataType__duckdb_driver Man page Source code
dbDisconnect,duckdb_connection-method Man page
dbDisconnect__duckdb_connection Man page Source code
dbExistsTable,duckdb_connection,ANY-method Man page
dbExistsTable__duckdb_connection_ANY Man page Source code
dbFetch,duckdb_result-method Man page
dbFetchArrow,duckdb_result_arrow-method Man page
dbFetchArrowChunk,duckdb_result_arrow-method Man page
dbFetchArrowChunk__duckdb_result_arrow Man page Source code
dbFetchArrow__duckdb_result_arrow Man page Source code
dbFetch__duckdb_result Man page Source code
dbGetInfo,duckdb_connection-method Man page
dbGetInfo,duckdb_driver-method Man page
dbGetInfo,duckdb_result-method Man page
dbGetInfo__duckdb_connection Man page Source code
dbGetInfo__duckdb_driver Man page Source code
dbGetInfo__duckdb_result Man page Source code
dbGetRowCount,duckdb_result-method Man page
dbGetRowCount,duckdb_result_arrow-method Man page
dbGetRowCount__duckdb_result Man page Source code
dbGetRowCount__duckdb_result_arrow Man page Source code
dbGetRowsAffected,duckdb_result-method Man page
dbGetRowsAffected,duckdb_result_arrow-method Man page
dbGetRowsAffected__duckdb_result Man page Source code
dbGetRowsAffected__duckdb_result_arrow Man page Source code
dbGetStatement,duckdb_result-method Man page
dbGetStatement,duckdb_result_arrow-method Man page
dbGetStatement__duckdb_result Man page Source code
dbGetStatement__duckdb_result_arrow Man page Source code
dbHasCompleted,duckdb_result-method Man page
dbHasCompleted,duckdb_result_arrow-method Man page
dbHasCompleted__duckdb_result Man page Source code
dbHasCompleted__duckdb_result_arrow Man page Source code
dbIsValid,duckdb_connection-method Man page
dbIsValid,duckdb_driver-method Man page
dbIsValid,duckdb_result-method Man page
dbIsValid,duckdb_result_arrow-method Man page
dbIsValid__duckdb_connection Man page Source code
dbIsValid__duckdb_driver Man page Source code
dbIsValid__duckdb_result Man page Source code
dbIsValid__duckdb_result_arrow Man page Source code
dbListFields,duckdb_connection,character-method Man page
dbListFields__duckdb_connection_character Man page Source code
dbListTables,duckdb_connection-method Man page
dbListTables__duckdb_connection Man page Source code
dbQuoteIdentifier,duckdb_connection,ANY-method Man page
dbQuoteIdentifier,duckdb_connection,Id-method Man page
dbQuoteIdentifier,duckdb_connection,SQL-method Man page
dbQuoteIdentifier,duckdb_connection,character-method Man page
dbQuoteIdentifier__duckdb_connection Source code
dbQuoteLiteral,duckdb_connection-method Man page
dbQuoteLiteral__duckdb_connection Man page Source code
dbRemoveTable,duckdb_connection,character-method Man page
dbRemoveTable__duckdb_connection_character Man page Source code
dbRollback,duckdb_connection-method Man page
dbRollback__duckdb_connection Man page Source code
dbSendQuery,duckdb_connection,character-method Man page
dbSendQueryArrow,duckdb_connection,character-method Man page
dbSendQueryArrow__duckdb_connection_character Man page Source code
dbSendQuery__duckdb_connection_character Man page Source code
dbWriteTable,duckdb_connection,character,data.frame-method Man page
dbWriteTable__duckdb_connection_character_data.frame Man page Source code
db_connection_describe.duckdb_connection Source code
dbplyr_edition.duckdb_connection Source code
default_conn Man page Source code
default_user_directory Source code
describe_storage Source code
df_is_materialized Source code
directory_override_with_source Source code
drv_to_string Source code
duckdb Man page Source code
duckdb-package Man page
duckdb_adbc Man page Source code
duckdb_augment_field_types_for_map Source code
duckdb_connection Man page Source code
duckdb_connection-class Man page
duckdb_convert_opts Source code
duckdb_convert_opts_impl Source code
duckdb_driver Man page
duckdb_driver-class Man page
duckdb_execute Source code
duckdb_execute_arrow Source code
duckdb_explain Man page
duckdb_explain-class Man page
duckdb_extension_storage Man page Source code
duckdb_fetch_arrow Man page Source code
duckdb_fetch_record_batch Man page Source code
duckdb_grepl Source code
duckdb_home_directory Source code
duckdb_is_map_type Source code
duckdb_list_arrow Man page Source code
duckdb_map_type_from_list_of Source code
duckdb_n_distinct Source code
duckdb_post_execute Source code
duckdb_progress_display Source code
duckdb_random_string Source code
duckdb_read_csv Man page Source code
duckdb_register Man page Source code
duckdb_register_arrow Man page Source code
duckdb_result Man page Source code
duckdb_result-class Man page
duckdb_result_arrow Man page Source code
duckdb_result_arrow-class Man page
duckdb_run_tests_enabled Source code
duckdb_secret_storage Man page Source code
duckdb_select_exprs_for_target Source code
duckdb_shared_home Source code
duckdb_shutdown Man page Source code
duckdb_storage Man page
duckdb_storage_config Man page
duckdb_storage_status Man page Source code
duckdb_target_column_types Source code
duckdb_unregister Man page Source code
duckdb_unregister_arrow Man page Source code
empty_arrow_chunk Source code
empty_arrow_stream Source code
encode_values Source code
examples_enabled Source code
expr_comparison Source code
expr_constant Source code
expr_function Source code
expr_operator Source code
expr_reference Source code
expr_set_alias Source code
expr_tostring Source code
expr_window Source code
expr_window_ Source code
extptr_str Source code
find_caller Source code
get_duckdb_version Source code
get_package_env Source code
get_package_name Source code
get_package_spec Source code
get_package_version Source code
get_progress_display Source code
get_reserved_words Source code
has_keep_marker Source code
head.duckdb_relation Source code
inform Source code
inform_duplicate_marker Source code
inform_once_every Source code
is_installed Source code
is_interactive Source code
is_memory_dbdir Source code
is_wholenumber Source code
is_windows Source code
load_rfuns Source code
local_con Source code
marked_storage_dir Source code
maybe_ephemeral_state_message Source code
migrate_storage Source code
migration_sources Source code
names.duckdb_relation Source code
now_seconds Source code
override_setting Source code
path_normalize Source code
persistent_roots Source code
pkg_method Source code
print.duckdb_explain Man page Source code
print.duckdb_expr Source code
print.duckdb_relation Source code
print.duckdb_storage_status Source code
rapi_adbc_init_func Source code
rapi_bind Source code
rapi_connect Source code
rapi_connection_valid Source code
rapi_disconnect Source code
rapi_error Source code
rapi_error_rlang Source code
rapi_execute Source code
rapi_execute_arrow Source code
rapi_expr_comparison Source code
rapi_expr_constant Source code
rapi_expr_function Source code
rapi_expr_operator Source code
rapi_expr_reference Source code
rapi_expr_set_alias Source code
rapi_expr_tostring Source code
rapi_expr_window Source code
rapi_fetch_arrow_array Source code
rapi_fetch_arrow_stream_into Source code
rapi_get_null_SEXP_ptr Source code
rapi_is_locked Source code
rapi_list_arrow Source code
rapi_load_rfuns Source code
rapi_lock Source code
rapi_prepare Source code
rapi_ptr_to_str Source code
rapi_record_batch Source code
rapi_register_arrow Source code
rapi_register_df Source code
rapi_rel_aggregate Source code
rapi_rel_alias Source code
rapi_rel_distinct Source code
rapi_rel_explain Source code
rapi_rel_filter Source code
rapi_rel_from_altrep_df Source code
rapi_rel_from_df Source code
rapi_rel_from_sql Source code
rapi_rel_from_table Source code
rapi_rel_from_table_function Source code
rapi_rel_insert Source code
rapi_rel_join Source code
rapi_rel_limit Source code
rapi_rel_names Source code
rapi_rel_order Source code
rapi_rel_project Source code
rapi_rel_set_alias Source code
rapi_rel_set_diff Source code
rapi_rel_set_intersect Source code
rapi_rel_set_symdiff Source code
rapi_rel_sql Source code
rapi_rel_to_altrep Source code
rapi_rel_to_csv Source code
rapi_rel_to_df Source code
rapi_rel_to_parquet Source code
rapi_rel_to_sql Source code
rapi_rel_to_table Source code
rapi_rel_to_view Source code
rapi_rel_tostring Source code
rapi_rel_union_all Source code
rapi_release Source code
rapi_shutdown Source code
rapi_startup Source code
rapi_unlock Source code
rapi_unregister_arrow Source code
rapi_unregister_df Source code
read_csv_duckdb Man page Source code
rel_aggregate Source code
rel_alias Source code
rel_distinct Source code
rel_explain Source code
rel_explain_df Source code
rel_filter Source code
rel_from_altrep_df Source code
rel_from_df Source code
rel_from_sql Source code
rel_from_table Source code
rel_from_table_function Source code
rel_inner_join Source code
rel_insert Source code
rel_join Source code
rel_limit Source code
rel_names Source code
rel_order Source code
rel_project Source code
rel_set_alias Source code
rel_set_diff Source code
rel_set_intersect Source code
rel_set_symdiff Source code
rel_sql Source code
rel_to_altrep Source code
rel_to_csv Source code
rel_to_parquet Source code
rel_to_sql Source code
rel_to_table Source code
rel_to_view Source code
rel_tostring Source code
rel_union_all Source code
release_bullets Source code
remove_keep_marker Source code
require_nanoarrow Source code
resolve_extension_directory Source code
resolve_secret_directory Source code
resolve_temp_directory Source code
rethrow_error_from_rapi Source code
rethrow_rapi_adbc_init_func Source code
rethrow_rapi_bind Source code
rethrow_rapi_connect Source code
rethrow_rapi_connection_valid Source code
rethrow_rapi_disconnect Source code
rethrow_rapi_execute Source code
rethrow_rapi_execute_arrow Source code
rethrow_rapi_expr_comparison Source code
rethrow_rapi_expr_constant Source code
rethrow_rapi_expr_function Source code
rethrow_rapi_expr_operator Source code
rethrow_rapi_expr_reference Source code
rethrow_rapi_expr_set_alias Source code
rethrow_rapi_expr_tostring Source code
rethrow_rapi_expr_window Source code
rethrow_rapi_fetch_arrow_array Source code
rethrow_rapi_fetch_arrow_stream_into Source code
rethrow_rapi_get_null_SEXP_ptr Source code
rethrow_rapi_is_locked Source code
rethrow_rapi_list_arrow Source code
rethrow_rapi_load_rfuns Source code
rethrow_rapi_lock Source code
rethrow_rapi_prepare Source code
rethrow_rapi_ptr_to_str Source code
rethrow_rapi_record_batch Source code
rethrow_rapi_register_arrow Source code
rethrow_rapi_register_df Source code
rethrow_rapi_rel_aggregate Source code
rethrow_rapi_rel_alias Source code
rethrow_rapi_rel_distinct Source code
rethrow_rapi_rel_explain Source code
rethrow_rapi_rel_filter Source code
rethrow_rapi_rel_from_altrep_df Source code
rethrow_rapi_rel_from_df Source code
rethrow_rapi_rel_from_sql Source code
rethrow_rapi_rel_from_table Source code
rethrow_rapi_rel_from_table_function Source code
rethrow_rapi_rel_insert Source code
rethrow_rapi_rel_join Source code
rethrow_rapi_rel_limit Source code
rethrow_rapi_rel_names Source code
rethrow_rapi_rel_order Source code
rethrow_rapi_rel_project Source code
rethrow_rapi_rel_set_alias Source code
rethrow_rapi_rel_set_diff Source code
rethrow_rapi_rel_set_intersect Source code
rethrow_rapi_rel_set_symdiff Source code
rethrow_rapi_rel_sql Source code
rethrow_rapi_rel_to_altrep Source code
rethrow_rapi_rel_to_csv Source code
rethrow_rapi_rel_to_df Source code
rethrow_rapi_rel_to_parquet Source code
rethrow_rapi_rel_to_sql Source code
rethrow_rapi_rel_to_table Source code
rethrow_rapi_rel_to_view Source code
rethrow_rapi_rel_tostring Source code
rethrow_rapi_rel_union_all Source code
rethrow_rapi_release Source code
rethrow_rapi_shutdown Source code
rethrow_rapi_startup Source code
rethrow_rapi_unlock Source code
rethrow_rapi_unregister_arrow Source code
rethrow_rapi_unregister_df Source code
rethrow_restore Source code
rs_actions Source code
rs_check_disabled Source code
rs_list_columns Source code
rs_list_object_types Source code
rs_list_objects Source code
rs_on_connection_closed Source code
rs_on_connection_opened Source code
rs_on_connection_updated Source code
rs_preview Source code
s3_register Source code
session_temp_dir Source code
set_csv_fields Source code
set_storage_marker Source code
show,duckdb_connection-method Man page
show,duckdb_driver-method Man page
show,duckdb_result-method Man page
show,duckdb_result_arrow-method Man page
show__duckdb_connection Man page Source code
show__duckdb_driver Man page Source code
show__duckdb_result Man page Source code
show__duckdb_result_arrow Man page Source code
simulate_duckdb Man page Source code
sql_escape_date.duckdb_connection Source code
sql_escape_datetime.duckdb_connection Source code
sql_exec Man page Source code
sql_expr_matches.duckdb_connection Source code
sql_query Man page Source code
sql_translation.duckdb_connection Source code
storage_dir Source code
storage_root_base Source code
system_file_path Source code
tbl.duckdb_connection Source code
tbl_file Man page Source code
tbl_function Man page Source code
tbl_query Man page Source code
tz_force Source code
tz_force_one Source code
write_keep_marker Source code
duckdb documentation built on July 10, 2026, 5:08 p.m.