R/dbQuoteIdentifier_PqConnection_Id.R
, R/dbQuoteIdentifier_PqConnection_SQL.R
, R/dbQuoteIdentifier_PqConnection_character.R
, and 5 more
quote.Rd
If an object of class Id is used for dbQuoteIdentifier()
, it needs
at most one table
component and at most one schema
component.
# S4 method for PqConnection,Id
dbQuoteIdentifier(conn, x, ...)
# S4 method for PqConnection,SQL
dbQuoteIdentifier(conn, x, ...)
# S4 method for PqConnection,character
dbQuoteIdentifier(conn, x, ...)
# S4 method for PqConnection
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,SQL
dbQuoteString(conn, x, ...)
# S4 method for PqConnection,character
dbQuoteString(conn, x, ...)
# S4 method for PqConnection,SQL
dbUnquoteIdentifier(conn, x, ...)
A PqConnection created by dbConnect()
A character vector to be quoted.
Other arguments needed for compatibility with generic (currently ignored).
library(DBI)
con <- dbConnect(RPostgres::Postgres())
x <- c("a", "b c", "d'e", "\\f")
dbQuoteString(con, x)
#> <SQL> 'a'
#> <SQL> 'b c'
#> <SQL> 'd''e'
#> <SQL> E'\\f'
dbQuoteIdentifier(con, x)
#> <SQL> "a"
#> <SQL> "b c"
#> <SQL> "d'e"
#> <SQL> "\f"
dbDisconnect(con)