Call this method to generate a string that is suitable for
use in a query as a column or table name, to make sure that you
generate valid SQL and protect against SQL injection attacks. The inverse
operation is dbUnquoteIdentifier().
# S4 method for DatabaseConnectorConnection,character
dbQuoteIdentifier(conn, x, ...)Arguments
- conn
A DBIConnection object, as returned by
dbConnect().- x
A character vector, SQL or Id object to quote as identifier.
- ...
Other arguments passed on to methods.
Value
dbQuoteIdentifier() returns an object that can be coerced to character,
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 returned object again to dbQuoteIdentifier()
as x
argument, it is returned unchanged. Passing objects of class SQL should also return them unchanged. (For backends it may be most convenient to return SQL objects to achieve this behavior, but this is not required.)
An error is raised if the input contains NA,
but not for an empty string.
See also
Other DBIResult generics:
DBIResult-class,
dbBind(),
dbClearResult(),
dbColumnInfo(),
dbFetch(),
dbGetInfo(),
dbGetRowCount(),
dbGetRowsAffected(),
dbGetStatement(),
dbHasCompleted(),
dbIsReadOnly(),
dbIsValid(),
dbQuoteLiteral(),
dbQuoteString(),
dbUnquoteIdentifier()