dbUnquoteIdentifier {DBI} | R Documentation |
Call this method to convert a SQL object created by dbQuoteIdentifier()
back to a list of Id objects.
dbUnquoteIdentifier(conn, x, ...)
conn |
A subclass of DBIConnection, representing an active connection to an DBMS. |
x |
An SQL or Id object or character vector, or a list of such objects, to unquote. |
... |
Other arguments passed on to methods. |
Other DBIResult generics: DBIResult-class
,
dbBind
, dbClearResult
,
dbColumnInfo
, dbFetch
,
dbGetInfo
, dbGetRowCount
,
dbGetRowsAffected
,
dbGetStatement
,
dbHasCompleted
, dbIsValid
,
dbQuoteIdentifier
,
dbQuoteLiteral
, dbQuoteString
# Unquoting allows to understand the structure of a # possibly complex quoted identifier dbUnquoteIdentifier( ANSI(), SQL(c('"Schema"."Table"', '"UnqualifiedTable"')) ) # The returned object is always a list, # also for Id objects or lists thereof dbUnquoteIdentifier( ANSI(), Id(schema = "Schema", table = "Table") ) dbUnquoteIdentifier( ANSI(), list(Id(schema = "Schema", table = "Table"), Id(table = "UnqualifiedTable")) ) # Lists of SQL objects can also be processed, # but each component must be length 1 dbUnquoteIdentifier( ANSI(), list(SQL('"Schema"."Table"'), SQL('"UnqualifiedTable"')) )