Get a database connection option.

Source: R/db_ops.R

Note: we are moving away from global options to options in the DB handle.

getDBOption(db, optname, default, connection_options = list())

Arguments

db

database connection handle.
optname

character, single option name.
default

what to return if not set.
connection_options

name list of per connection options.

Value

option value

Examples


if(requireNamespace("DBI", quietly = TRUE) && requireNamespace("RSQLite", quietly = TRUE)) {
  my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  print(getDBOption(my_db, "use_DBI_dbExecute"))
  DBI::dbDisconnect(my_db)
}

#> NULL