dbCreateTableAs: Create a table in database using a statement

dbCreateTableAsR Documentation

Create a table in database using a statement

Description

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.


RPresto documentation built on Nov. 2, 2023, 5:58 p.m.