Quote identifiers — dbQuoteIdentifier

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(). Methods in other packagesThis documentation page describes the generics. Refer to the documentation pages linked below for the documentation for the methods that are implemented in various backend packages. adbi::dbQuoteIdentifier("AdbiConnection", "character") bigrquery::dbQuoteIdentifier("BigQueryConnection", "character") bigrquery::dbQuoteIdentifier("BigQueryConnection", "SQL") DatabaseConnector::dbQuoteIdentifier("DatabaseConnectorConnection", "character") dittodb::dbQuoteIdentifier("DBIMockRPostgresConnection", "character") dittodb::dbQuoteIdentifier("DBIMockRPostgresConnection", "SQL") duckdb::dbQuoteIdentifier("duckdb_connection", "ANY") duckdb::dbQuoteIdentifier("duckdb_connection", "character") duckdb::dbQuoteIdentifier("duckdb_connection", "Id") duckdb::dbQuoteIdentifier("duckdb_connection", "SQL") implyr::dbQuoteIdentifier("impala_connection", "character") implyr::dbQuoteIdentifier("impala_connection", "dbplyr_table_ident") odbc::dbQuoteIdentifier("OdbcConnection", "character") pool::dbQuoteIdentifier("Pool", "ANY") RMariaDB::dbQuoteIdentifier("MariaDBConnection", "character") RMariaDB::dbQuoteIdentifier("MariaDBConnection", "Id") RMariaDB::dbQuoteIdentifier("MariaDBConnection", "SQL") RMySQL::dbQuoteIdentifier("MySQLConnection", "character") RPostgres::dbQuoteIdentifier("PqConnection", "character") RPostgres::dbQuoteIdentifier("PqConnection", "Id") RPostgres::dbQuoteIdentifier("PqConnection", "SQL") RPresto::dbQuoteIdentifier("PrestoConnection", "dbplyr_schema") RSQLite::dbQuoteIdentifier("SQLiteConnection", "character") RSQLite::dbQuoteIdentifier("SQLiteConnection", "SQL") sparklyr::dbQuoteIdentifier("spark_connection", "character")