Categories
status

Connecting PostgreSQL from R using RdbiP …

Connecting PostgreSQL from R using RdbiPgSQL

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)
Categories
status

Control flow of postgresql with examples …

Control flow of postgresql with examples.

http://www.commandprompt.com/ppbook/x20238