Last data update: 2014.03.03
|
R: Build the SQL CREATE TABLE definition as a string
postgresqlBuildTableDefinition | R Documentation |
Build the SQL CREATE TABLE definition as a string
Description
Build the SQL CREATE TABLE definition as a string for the
input data.frame
Usage
postgresqlBuildTableDefinition(dbObj, name, obj, field.types = NULL, row.names = TRUE, ...)
Arguments
dbObj |
any DBI object (used only to dispatch according to the
engine (e.g., MySQL, Oracle, PostgreSQL, SQLite)
|
name |
name of the new SQL table
|
obj |
an R object coerceable to data.frame for which we want
to create a table
|
field.types |
optional named list of the types for each field
in obj
|
row.names |
logical, should row.name of value be exported
as a row_names field? Default is TRUE
|
... |
reserved for future use
|
Details
The output SQL statement is a simple CREATE TABLE with
suitable for dbGetQuery
Value
An SQL string
References
See the Database Interface definition document
DBI.pdf in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
See Also
PostgreSQL ,
dbConnect ,
dbSendQuery ,
dbGetQuery ,
fetch ,
dbCommit ,
dbGetInfo ,
dbReadTable .
Results
|