appendTable: Append a Table

In patelm9/pg13: pg13 Package

Description

Like the writeTable function, this function is a wrapper around a DatabaseConnector function rather than one where a SQL statement is rendered using the SqlRender package. This function performs the additional step of converting all inputs to the data.frame class, especially in cases where the input is a tibble.

Usage

appendTable(
  conn,
  conn_fun,
  schema,
  tableName,
  data,
  verbose = TRUE,
  render_sql = TRUE,
  ...
)

Arguments

conn	Connection object
schema	The target schema for the operation.
tableName	The target table in the schema for an operation or for writing functions, the name of the table that will be created.
data	A dataframe or tibble.
verbose	If TRUE, details on the activity are returned in the console, such as when the querying starting and was completed.
render_sql	If TRUE, the SQL statement for the operation is returned in the console.
...	Additional arguments passed to DatabaseConnector::dbAppendTable()

See Also

Other table functions: append_table(), create_table_from_df(), create_table(), drop_all_staging_tables(), drop_table_batch(), drop_table(), read_table(), searchTable(), search_table(), write_staging_table(), write_table()

patelm9/pg13 documentation built on Dec. 26, 2021, 8:17 p.m.