sqlCreateTable,GreenplumConnection-method {RGreenplum}

Greenplum sqlCreateTable method

Description

Greenplum sqlCreateTable method

Usage

## S4 method for signature 'GreenplumConnection'
sqlCreateTable(con, table, fields,
  row.names = NA, temporary = FALSE, distributed_by = NULL, ...)

Arguments

con

A database connection.

table

Name of the table. Escaped with [dbQuoteIdentifier()].

fields

Either a character vector or a data frame.

A named character vector: Names are column names, values are types. Names are escaped with [dbQuoteIdentifier()]. Field types are unescaped.

A data frame: field types are generated using [dbDataType()].

row.names

Either TRUE, FALSE, NA or a string.

If TRUE, always translate row names to a column called "row_names". If FALSE, never translate row names. If NA, translate rownames only if they're a character vector.

A string is equivalent to TRUE, but allows you to override the default name.

For backward compatibility, NULL is equivalent to FALSE.

temporary

If 'TRUE', will generate a temporary table statement.

distributed_by

Distribution columns for new table. NULL for random distribution.

...

Other arguments used by individual methods.