Advertisement
Guest User

Untitled

a guest
Aug 11th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. library(readxl, quietly=TRUE)
  2. df <- read_excel("d:/my.xlsx",col_names = TRUE)
  3.  
  4. library(RPostgreSQL)
  5. drv <- dbDriver("PostgreSQL")
  6. con <- dbConnect(drv, user='postgres', password='', dbname='alitrack', host='postgres.alitrack.com')
  7.  
  8. postgresqlpqExec(con, "SET client_encoding = 'GBK'")
  9.  
  10. dbWriteTable(con, c("my_schema","my_table"), data.frame(df), row.names = FALSE)
  11. # Free up resources
  12. dbDisconnect(con)
  13. dbUnloadDriver(drv)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement