[R] connecting R and PostgreSQL

[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, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
> On Tue, Jun 28, 2011 at 8:15 AM,  <Aya74656 at gmx.de> 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 RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the second doesn't work with R version 2.13).
>>
>> Could someone please be so kind to either provide a step-by-step instruction on how to make this connection work or direct me to a manual?
>>
>
> For RpgSQL there is installation info if you click on the Installation
> link here:
>
> http://cran.r-project.org/web/packages/RpgSQL/index.html
>
> and the same info is in the INSTALL file in the package.
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>