R and Postgres
Excellent, thank you to everyone who helped!
This is what I did to install the packages:
install.packages(c('Rdbi','RdbiPgSQL'), repos="
http://bioconductor.org/packages/1.9/bioc/", dependencies=TRUE)
And then I followed Steve Henshaw's generic example:
On Tue, Jul 1, 2008 at 1:29 PM, Steve Henshaw <steve.henshaw at gmail.com>
wrote:
Hi I run postgre 8.3 on linux and can access it, ive put a generic example of how I got it to work below, ive only used it for a database on a local machine. Hope it gives you a start :) ######### library(Rdbi) library(RdbiPgSQL) #establish connection conn <- dbConnect(PgSQL(),host='host',dbname='mydatabasename',user='me') #send query query <- dbSendQuery(conn,"select * from my table") #get results results <- dbGetResult(query) #close connection dbDisconnect(conn) ################
Bryce B. Baril MarketOutsider.com [[alternative HTML version deleted]]