toSQLStringSet

Convert a vector to a quoted string for use as a SQL value list

Given a vector, this function returns a string with each element of the input coerced to character, quoted, and separated by ",".

Keywords
manip, utilities
Usage
toSQLStringSet(names)
Arguments
names
A vector of values to quote
Details

If names is a character vector with elements containing single quotes, these quotes will be doubled so as to escape the quote in SQL.

Value

A character vector of length one that represents the input vector as a SQL value list. Each element is single quoted and elements are comma separated.

Note

Do not use sQuote for generating SQL as that function is intended for display purposes only. In some locales, sQuote will generate fancy quotes which will break your SQL.

Aliases
  • toSQLStringSet
Examples
toSQLStringSet(letters[1:4])
toSQLStringSet(c("'foo'", "ab'cd", "bar"))

Documentation reproduced from package AnnotationDbi, version 1.34.4, License: Artistic-2.0

Community examples

Looks like there are no examples yet.