Re: [R] connecting R and PostgreSQL

2011-06-29 Thread Hugo Mildenberger
Marie, you did not say if you work on Windows or Unix. The manual from google belongs to the R package RpostgreSQL. This package makes use the native PostgreSQL driver. As I read the documentation, the package's DBI interface must be somehow binary compatible with the Postgres version installed. I

Re: [R] connecting R and PostgreSQL

2011-06-28 Thread Steven Kennedy
I use RODBC and have got it to work fine on Windows, Linux and Mac. There's some basic info here, and plenty of blog posts out there with step by step instructions for the different OS's. http://hosho.ees.hokudai.ac.jp/~kubo/Rdoc/library/RODBC/html/00Index.html On Tue, Jun 28, 2011 at 11:53 PM

Re: [R] connecting R and PostgreSQL

2011-06-28 Thread Gabor Grothendieck
On Tue, Jun 28, 2011 at 8:15 AM, wrote: > Dear R-helpers, > > I'm an absolute beginner using both R and PostgreSQL, but now I have to work > with both programs. I need to connect R and my Postgres-database, but every > attempt so far has failed (I tried using the RpgSQL package as well as > Rd