in_schema {dbplyr} | R Documentation |
in_schema()
can be used in tbl()
to indicate a table in a specific
schema.
in_catalog()
additionally allows specifying the database catalog.
in_schema(schema, table) in_catalog(catalog, schema, table)
catalog, schema, table |
Names of catalog, schema, and table.
These will be automatically quoted; use |
in_schema("my_schema", "my_table") in_catalog("my_catalog", "my_schema", "my_table") # eliminate quotes in_schema(sql("my_schema"), sql("my_table")) # Example using schemas with SQLite con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:") # Add auxilary schema tmp <- tempfile() DBI::dbExecute(con, paste0("ATTACH '", tmp, "' AS aux")) library(dplyr, warn.conflicts = FALSE) copy_to(con, iris, "df", temporary = FALSE) copy_to(con, mtcars, in_schema("aux", "df"), temporary = FALSE) con %>% tbl("df") con %>% tbl(in_schema("aux", "df"))