Skip to contents

Create a table in database using a statement

Source: R/dbCreateTableAs.R
dbCreateTableAs.Rd

Create a table in database using a statement

Usage

dbCreateTableAs(conn, name, sql, overwrite = FALSE, with = NULL, ...)

Arguments

conn

A DBIConnection object, as returned by dbConnect().

name

The table name, passed on to dbQuoteIdentifier(). Options are:

  • a character string with the unquoted DBMS table name, e.g. "table_name",

  • a call to Id() with components to the fully qualified table name, e.g. Id(schema = "my_schema", table = "table_name")

  • a call to SQL() with the quoted and fully qualified table name given verbatim, e.g. SQL('"my_schema"."table_name"')

sql

a character string containing SQL statement.

overwrite

A boolean indicating if an existing table should be overwritten. Default to FALSE.

with

An optional WITH clause for the CREATE TABLE statement.

...

Other parameters passed on to methods.