db_exec {duckplyr} | R Documentation |
Execute a statement for the default connection
Description
The duckplyr package relies on a DBI connection
to an in-memory database.
The db_exec()
function allows running SQL statements
with side effects on this connection.
It can be used to execute statements that start with
PRAGMA
, SET
, or ATTACH
to, e.g., set up credentials, change configuration options,
or attach other databases.
See https://duckdb.org/docs/configuration/overview.html
for more information on the configuration options,
and https://duckdb.org/docs/sql/statements/attach.html
for attaching databases.
Usage
db_exec(sql, ..., con = NULL)
Arguments
sql |
The statement to run. |
... |
These dots are for future extensions and must be empty. |
con |
The connection, defaults to the default connection. |
Value
The return value of the DBI::dbExecute()
call, invisibly.
See Also
Examples
db_exec("SET threads TO 2")
[Package duckplyr version 1.1.0 Index]