dbWriteTable,GreenplumConnection,character,data.frame-method {RGreenplum}

Greenplum dbWriteTable method

Description

Greenplum dbWriteTable method

Greenplum dbExistsTable method

Usage

## 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