homme cherche compagnie Connecting PostgreSQL from R using RdbiPgSQL

shamelessly library(RdbiPgSQL) conn <- dbConnect(PgSQL(), host="localhost", dbname="my_database", user="my_user", password="my_secret_password") res <- dbSendQuery(conn, "select * from prices where item_id = 29") mydata <- dbGetResult(res) ... dbDisconnect(conn)