mainscntanalysis/firstDbSteps.r

8 lines
217 B
R

library(DBI)
con <- dbConnect(RPostgres::Postgres(), dbname='mainscnt', host='db.mainscnt.eu', user='wn')
res <-dbSendQuery(con, "select * from device_t")
devices <- dbFetch(res)
dbClearResult(res)
dbDisconnect(con)