[R] DBI Package

[Prof Brian Ripley]

On Wed, 31 Oct 2007, Germán Carrillo wrote:

> Hello everyone!
>
> Congratulations by this gorgeous software.
>
> My name is Germán Carrillo, I'm writting from Colombia. I don't have much
> experience with R, reason why I use the R-GUI (version 2.5.1) on Windows.
>
> I have some problems with DBI package, I want to connect to PostgreSQL
> database but I don't know the way to do it.

As far as I am aware DBI does not currently have a PostgreSQL driver.  To 
connect to PostgreSQL you can use RODBC (easy) or RdbiPgSQL (and Rdbi) 
from Bioconductor, which uses a precursor to DBI.  Unfortunately, I don't 
see a Windows binary for RdbiPgSQL on the Bioconductor site so you would 
need to compile it from sources (not easy).

> I was reading the DBI manual and I tried write in my R Console the next
> command:
>
> pg <- dbDriver("PostgreSQL")
>
> But R says:
>         Error en do.call(as.character(drvName), list(...)) :
>        no se pudo encontrar la función "PostgreSQL"
>
> I don't know what's happen, I would like to receive some help about this
> topic, I was looking for in the internet but there's few documentation about
> this package.
>
>
> Thanks in advance.
>
> Best regards.
>
> Pdt: Sorry by my english, I'm learning... :)
>
>
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595