sqlAppendTableAs: Compose query to append to a table using a statement

sqlAppendTableAsR Documentation

Compose query to append to a table using a statement

Description

Compose query to append to a table using a statement

Usage

sqlAppendTableAs(con, name, sql, auto_reorder = TRUE, ...)

Arguments

con

A database connection.

name

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

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

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

  • a call to DBI::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, or a tbl_presto object.

auto_reorder

Logical (default TRUE). If TRUE, automatically reorders query columns to match table column order when column names match but order differs. If FALSE, columns are inserted in query order.

...

Other arguments used by individual methods.


RPresto documentation built on Dec. 2, 2025, 9:07 a.m.