# Connect to DuckDB
con <- DBI::dbConnect(duckdb::duckdb(dbdir = tempfile()))
# List all database settings
list_setting(con)
# Disconnect
DBI::dbDisconnect(con)List Database Settings
Source: R/utils-md.R
The list_setting() function provides a convenient way to inspect the active configuration of a DuckDB or MotherDuck connection. It executes the internal DuckDB function duckdb_settings() and returns the results as a tidy tibble for easy viewing or filtering.
Usage
list_setting(.con)Arguments
Value
A tibble::tibble containing one row per setting with columns describing the setting name, current value, description, and default value.
Details
This function is particularly useful for debugging or auditing runtime environments. All settings are returned as character columns, including their names, current values, and default values.
See Also
Other db-list: list_all_databases(), list_all_tables(), list_current_schemas(), list_current_tables(), list_extensions(), list_fns(), list_shares()