greenplum-tables function

Greenplum dbWriteTable method

Greenplum dbWriteTable method

Greenplum dbExistsTable method methods

## S4 method for signature 'GreenplumConnection,character,data.frame'
dbWriteTable(conn, name,
  value, ..., row.names = FALSE, overwrite = FALSE, append = FALSE,
  field.types = NULL, temporary = FALSE, distributed_by = NULL,
  copy = TRUE)

## S4 method for signature 'GreenplumConnection,character'
dbExistsTable(conn, name, ...)

Arguments

• conn: a [GreenplumConnection-class] object
• 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.
• ...: Other arguments used by individual methods.
• row.names: Either TRUE, FALSE, NA or a string
• overwrite: a logical specifying whether to overwrite an existing table or not. Its default is FALSE.
• append: a logical specifying whether to append to an existing table in the DBMS. Its default is FALSE.
• field.types: character vector of named SQL field types where the names are the names of new table's columns.
• temporary: If TRUE, will generate a temporary table statement.
• distributed_by: Distribution columns for new table. NULL for random distribution.
• copy: If TRUE, data will be copied to remote database