R help - Oct 2007 - DBI Package

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.

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... :)


-- 
-----------
  |\__
(:>__)(
  |/

Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/

	[[alternative HTML version deleted]]

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

> I have some problems with DBI package, I want to connect to PostgreSQL
> database but I don't know the way to do it.
>
> pg <- dbDriver("PostgreSQL")
... nope.  That won't work.

you need the RdbiPgSQL package from Bioconductor.  Along with DBI, as I 
recall.

--elijah
-------------- next part --------------
______________________________________________
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.