dbTableNameFix: Format input for database schema/table names.

In rpostgis: R Interface to a 'PostGIS' Database

Format input for database schema/table names.

Description

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

Usage

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 identifiers (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

## 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)

rpostgis documentation built on Nov. 20, 2023, 5:07 p.m.