Format input for database schema/table names.

Share:

Description

Internal rpostgis function to return common (length = 2) schema and table name vector from various table and schema + table name inputs.

Usage

1
dbTableNameFix(conn = NULL, t.nm, as.identifier = TRUE)

Arguments

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 identifers (TRUE) or as regular character (FALSE)

Value

character vector of length 2. Each character element is in (escaped) double-quotes when as.identifier = TRUE.

Examples

 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)