Using RPostgreSQL package I have to do a query with a vector
in the string
:
dbGetQuery(con, "select from id_table where id_user in tmp")
Where tmp
should be a list or a vector of length= 10k, how can I do this? Thanks.
Using RPostgreSQL package I have to do a query with a vector
in the string
:
dbGetQuery(con, "select from id_table where id_user in tmp")
Where tmp
should be a list or a vector of length= 10k, how can I do this? Thanks.
You can use paste0. Here is an example where I take the state.abb dataset