Description Usage Arguments Value Author(s) Examples
Internal rpostgis function to return common (length = 2) schema and table name vector from various table and schema + table name inputs.
1 | dbTableNameFix(conn = NULL, t.nm, as.identifier = TRUE)
|
conn |
A connection object. Must be provided but can be set NULL, where a dummy connection will be used. |
t.nm |
Table name string, length 1-2. |
as.identifier |
Boolean whether to return (schema,table) name as database sanitized identifiers (TRUE) or as regular character (FALSE) |
character vector of length 2. Each character element is in (escaped) double-quotes when as.identifier = TRUE.
David Bucklin
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | ## Not run:
name<-c("schema","table")
dbTableNameFix(conn,name)
#current search path schema is added to single-length character object (if only table is given)
name<-"table"
dbTableNameFix(conn,name)
#schema or table names with double quotes should be given exactly as they are
(make sure to wrap in single quotes in R):
name<-c('sch"ema','"table"')
dbTableNameFix(conn,name)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.