[R] Unable to connect to PostgreSQL

[Prof Brian Ripley]

It looks like you are trying to use package DBI (without telling us). That 
is of no use without a specific DBMS interface, e.g. packages RMySQL, 
ROracle and RSQLite.

AFAIK, there is no DBI interface to PostgreSQL.  RODBC works well, RJDBC 
may well work (if Java works for your system) and there is a different 
interface via Rdbi from (nowadays) the Bioconductor project.

[Please do note the footer of this message.]


On Thu, 15 Feb 2007, Ravi S. Shankar wrote:

> Hi R users,
>
>
>
> I am a beginner trying to connect to PostgreSQL using R
>
>
>
> When I give the following command     drv<-dbDriver("PostgreSQL")
>
>
>
> I am getting the following error    Error in
> do.call(as.character(drvName), list(...)) :  could not find function
> "PostgreSQL"
>
>
>
> I have installed PostgreSQL 8.1 in my system. I am currently using R
> 2.3.1.
>
>
>
> Any help would be welcome
>
> Thanks
>
>
>
> Ravi
>
>
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>

-- 
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