hidden_aliases function

methods

Greenplum sqlCreateTable method

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