Description Usage Arguments Examples
Convenience functions for reading/writing DBMS tables
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 | ## S4 method for signature 'OdbcConnection,character,data.frame'
dbWriteTable(
conn,
name,
value,
overwrite = FALSE,
append = FALSE,
temporary = FALSE,
row.names = NA,
field.types = NULL,
batch_rows = getOption("odbc.batch_rows", NA),
...
)
## S4 method for signature 'OdbcConnection,Id,data.frame'
dbWriteTable(
conn,
name,
value,
overwrite = FALSE,
append = FALSE,
temporary = FALSE,
row.names = NA,
field.types = NULL,
batch_rows = getOption("odbc.batch_rows", NA),
...
)
## S4 method for signature 'OdbcConnection,SQL,data.frame'
dbWriteTable(
conn,
name,
value,
overwrite = FALSE,
append = FALSE,
temporary = FALSE,
row.names = NA,
field.types = NULL,
batch_rows = getOption("odbc.batch_rows", NA),
...
)
## S4 method for signature 'OdbcConnection'
dbAppendTable(conn, name, value, ..., row.names = NULL)
## S4 method for signature 'OdbcConnection'
sqlData(con, value, row.names = NA, ...)
## S4 method for signature 'OdbcConnection'
sqlCreateTable(
con,
table,
fields,
field.types = NULL,
row.names = NA,
temporary = FALSE,
...
)
|
conn |
a |
name |
a character string specifying a table name. Names will be automatically quoted so you can use any sequence of characters, not just any valid bare table name. |
value |
A data.frame to write to the database. |
overwrite |
Allow overwriting the destination table. Cannot be
|
append |
Allow appending to the destination table. Cannot be
|
temporary |
If |
row.names |
Either If A string is equivalent to For backward compatibility, |
field.types |
Additional field types used to override derived types. |
batch_rows |
The number of rows to retrieve. Defaults to |
... |
Other arguments used by individual methods. |
con |
A database connection. |
table |
Name of the table. Escaped with
|
fields |
Either a character vector or a data frame. A named character vector: Names are column names, values are types.
Names are escaped with A data frame: field types are generated using
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | ## Not run:
library(DBI)
con <- dbConnect(odbc::odbc())
dbListTables(con)
dbWriteTable(con, "mtcars", mtcars, temporary = TRUE)
dbReadTable(con, "mtcars")
dbListTables(con)
dbExistsTable(con, "mtcars")
# A zero row data frame just creates a table definition.
dbWriteTable(con, "mtcars2", mtcars[0, ], temporary = TRUE)
dbReadTable(con, "mtcars2")
dbDisconnect(con)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.