Guest User

Untitled

a guest
Feb 28th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. library(glue)
  2. library(RPostgreSQL)
  3. library(DBI)
  4.  
  5. drv <- dbDriver("PostgreSQL")
  6. con <- dbConnect(drv,
  7. host=Sys.getenv("JDBCURL"),
  8. port = Sys.getenv("PORT"),
  9. dbname = Sys.getenv("DBNAME"),
  10. user = Sys.getenv("USER"),
  11. password = Sys.getenv("PW"))
  12.  
  13. users_syntax <- "123, 1234, 12345"
  14.  
  15. query <- glue("
  16. INSERT INTO table_name (user_id)
  17. VALUES ({users})",
  18. users = users_syntax)
  19. %>% as.character
  20.  
  21. dbSendQuery(con, query)
Add Comment
Please, Sign In to add comment