1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
%% TODO: Should we move this to the DBI package?
\name{postgresqlBuildTableDefinition}
\alias{postgresqlBuildTableDefinition}
\title{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{
\item{dbObj}{any DBI object (used only to dispatch according to the
engine (e.g., MySQL, Oracle, PostgreSQL, SQLite) }
\item{name}{name of the new SQL table}
\item{obj}{an R object coerceable to data.frame for which we want
to create a table}
\item{field.types}{optional named list of the types for each field
in \code{obj}}
\item{row.names}{logical, should row.name of \code{value} be exported
as a \code{row\_names} field? Default is TRUE}
\item{\dots}{reserved for future use}
}
\details{
The output SQL statement is a simple \code{CREATE TABLE} with
suitable for \code{dbGetQuery}
}
\value{
An SQL string
}
\references{
See the Database Interface definition document
\code{DBI.pdf} in the base directory of this package
or \url{https://cran.r-project.org/package=DBI}.
}
\seealso{
\code{\link{PostgreSQL}},
\code{\link[DBI]{dbConnect}},
\code{\link[DBI]{dbSendQuery}},
\code{\link[DBI]{dbGetQuery}},
\code{\link[DBI]{fetch}},
\code{\link[DBI]{dbCommit}},
\code{\link[DBI]{dbGetInfo}},
\code{\link[DBI]{dbReadTable}}.
}
\keyword{methods}
\keyword{interface}
\keyword{database}
%% vim: syntax=tex
|
