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 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
|
% $Id: make.db.names-methods.Rd,v 0.1 2008/07/22 03:16:22 psk Exp $
\name{make.db.names-methods}
\docType{methods}
\alias{SQLKeywords-methods}
\alias{isSQLKeyword-methods}
\alias{make.db.names,PostgreSQLObject,character-method}
\alias{SQLKeywords,PostgreSQLObject-method}
\alias{SQLKeywords,missing-method}
\alias{isSQLKeyword,PostgreSQLObject,character-method}
\title{
Make R/S-Plus identifiers into quoted PostgreSQL identifiers
}
\description{
Calls postgresqlquoteId to make valid quoted identifiers.
This has calling convention same as the make.db.names for compatibility.
}
\section{Methods}{\describe{
\item{dbObj}{
any PostgreSQL object (e.g., \code{PostgreSQLDriver}). Just ignored.
}
\item{snames}{
a character vector of R/S-Plus identifiers (symbols) from which
we need to make SQL identifiers.
}
\item{name}{
a character vector of SQL identifiers we want to check against
keywords from the DBMS. Ignored.
}
\item{unique}{
logical describing whether the resulting set of SQL names should
be unique. Its default is \code{TRUE}. Following the SQL 92
standard, uniqueness of SQL identifiers is determined regardless
of whether letters are upper or lower case. Ignored.
}
\item{allow.keywords }{
logical describing whether SQL keywords should be allowed in the
resulting set of SQL names. Its default is \code{TRUE}. Ignored.
}
\item{keywords}{
a character vector with SQL keywords, by default it is
\code{.PostgreSQLKeywords} define in \code{RPostgreSQL}. This may
be overriden by users. Ignored.
}
\item{case}{
a character string specifying whether to make the comparison
as lower case, upper case, or any of the two.
it defaults to \code{any}. Ignored.
}
\item{\dots}{currently not used.}
}
}
\references{
The set of SQL keywords is stored in the character vector
\code{.SQL92Keywords} and reflects the SQL ANSI/ISO standard as
documented in "X/Open SQL and RDA", 1994, ISBN 1-872630-68-8.
Users can easily override or update this vector.
PostgreSQL does add some keywords to the SQL 92 standard, they are
listed in the \code{.PostgreSQLKeywords} object.
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]{dbReadTable}},
\code{\link[DBI]{dbWriteTable}},
\code{\link[DBI]{dbExistsTable}},
\code{\link[DBI]{dbRemoveTable}},
\code{\link[DBI]{dbListTables}}.
}
\examples{\dontrun{
# This example shows how we could export a bunch of data.frames
# into tables on a remote database.
}
}
\keyword{methods}
\keyword{interface}
\keyword{database}
% vim: syntax=tex
|