Guest User

Untitled

a guest
Mar 25th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. library(DBI)
  2. library(odbc)
  3. library(RPostgreSQL)
  4.  
  5. # ODBC
  6. con <- dbConnect(odbc::odbc(), Driver = "postgresql", Server = cred[[1]], UID = cred[[2]],
  7. Database = cred[[3]], PWD = cred[[4]], Port = "5432")
  8. #RPostgreSQL
  9. con <- dbConnect(RPostgreSQL::PostgreSQL(), host = cred[[1]], user = cred[[2]],
  10. dbname = cred[[3]], password = cred[[4]])
  11.  
  12. if (!dbExistsTable(con, "indianajones")) {
  13. dbWriteTable(con, "indianajones", data)
  14. }
Add Comment
Please, Sign In to add comment