RPostgres (version 1.0-4)

quote: Quote postgres strings and identifiers.

Description

Quote postgres strings and identifiers.

Usage

# S4 method for PqConnection,character
dbQuoteString(conn, x, ...)
# S4 method for PqConnection,SQL
dbQuoteString(conn, x, ...)
# S4 method for PqConnection,character
dbQuoteIdentifier(conn, x, ...)
# S4 method for PqConnection,SQL
dbQuoteIdentifier(conn, x, ...)
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,logical
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,integer
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,numeric
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,factor
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,Date
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,POSIXt
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,difftime
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,list
dbQuoteLiteral(conn, x, ...)
# S4 method for PqConnection,blob
dbQuoteLiteral(conn, x, ...)

Arguments

conn

A '>PqConnection created by dbConnect()

x

A character to escaped

...

Other arguments needed for compatibility with generic

Examples

# NOT RUN {
# For running the examples on systems without PostgreSQL connection:
run <- postgresHasDefault()

library(DBI)
if (run) con <- dbConnect(RPostgres::Postgres())

x <- c("a", "b c", "d'e", "\\f")
if (run) dbQuoteString(con, x)
if (run) dbQuoteIdentifier(con, x)
if (run) dbDisconnect(con)
# }