Advertisement
Guest User

Untitled

a guest
Apr 21st, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. require(RPostgreSQL)
  2. require(df)
  3.  
  4. drv = dbDriver("PostgreSQL")
  5. con = dbConnect(drv, dbname = DBname_1, user = DBuser, host = DBhost, port = DBport, password = DBpassword)
  6.  
  7. dat = st_read_db(con, table = "schema1.table1",
  8. query = "SELECT * FROM schema1.table1")
  9.  
  10. dbDisconnect(con)
  11. dbUnloadDriver(drv)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement