[R] DBI Package
Prof Brian Ripley
ripley at stats.ox.ac.uk
Wed Oct 31 07:53:24 CET 2007
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
> 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
More information about the R-help