Call this method to convert a SQL object created by
back to a list of Id objects.
A subclass of DBIConnection, representing an active connection to an DBMS.
An SQL or Id object or character vector to unquote.
Other arguments passed on to methods.
dbUnquoteIdentifier() returns a list of objects
of the same length as the input.
For an empty character vector this function returns a length-0 object.
The names of the input argument are preserved in the output.
When passing the first element of a returned object again to
argument, it is returned unchanged (but wrapped in a list).
Passing objects of class Id should also return them unchanged (but wrapped in a list).
(For backends it may be most convenient to return Id objects
to achieve this behavior, but this is not required.)
An error is raised if plain character vectors are passed as the
For any character vector of length one, quoting (with
then unquoting then quoting the first element is identical to just quoting.
This is also true for strings that
contain special characters such as a space,
or quotes used to mark strings
if the database supports this.
Unquoting simple strings (consisting of only letters) wrapped with
and then quoting gives the same result as just quoting.
Other DBIResult generics:
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
# 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 dbUnquoteIdentifier( ANSI(), Id(schema = "Schema", table = "Table") ) # Quoting is the inverse operation to unquoting the elements # of the returned list dbQuoteIdentifier( ANSI(), dbUnquoteIdentifier(ANSI(), SQL("UnqualifiedTable"))[] ) dbQuoteIdentifier( ANSI(), dbUnquoteIdentifier(ANSI(), Id(schema = "Schema", table = "Table"))[] )
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.