postgresqlBuildTableDefinition

0th

Percentile

Build the SQL CREATE TABLE definition as a string

Build the SQL CREATE TABLE definition as a string for the input data.frame

Keywords
methods, interface, database
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 https://cran.r-project.org/package=DBI.

See Also

PostgreSQL, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.

Aliases
  • postgresqlBuildTableDefinition
Documentation reproduced from package RPostgreSQL, version 0.6-2, License: GPL-2 | file LICENSE

Community examples

Looks like there are no examples yet.