[R-sig-DB] R/PostgreSQL

[Meike Börder]

Dear all,

 

I have two problems while using R and PostgreSQL 9.0 and need some help.

 

1)      I want to import tables from a specific PostgreSQL-Database into R.

Connecting R to PostgreSQL using dbConnect worked, but instead of showing
just the tables in the requested database, R returned every single table
from all databases.

 

I used these commands:

conRLP <- dbConnect(pgSQL(), user = "postgres", password = "pw�, dbname =
"Data RLP")

 

dbListTables(conRLP)  

 

and now instead of just the 15 tables from �Data RLP� I need, I see a list
of all tables. Is there a way to just show the tables that are in Data RLP?

 

My session info:

R version 2.13.2 (2011-09-30)

Platform: i386-pc-mingw32/i386 (32-bit)

 

locale:

[1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252
LC_MONETARY=German_Germany.1252 LC_NUMERIC=C
LC_TIME=German_Germany.1252    

 

attached base packages:

[1] stats     graphics  grDevices utils     datasets  methods   base

 

 

2)      I tried to install RPostgreSQL, but got an error report that the
confirmation failed.

 

install.packages("RPostgreSQL", type="source")

Installiere Paket(e) nach �C:/Users/Hinata/Documents/R/win-library/2.13�
#translation from german: install packages to C:/�

(da �lib� nicht spezifiziert)
#�lib� not specified

versuche URL 'http://cran.rakanu.com/src/contrib/RPostgreSQL_0.2-0.tar.gz'
#tries URL �http://��

Content type 'application/x-gzip' length 159167 bytes (155 Kb)

URL ge�ffnet
#URL opened

downloaded 155 Kb

 

* installing *source* package 'RPostgreSQL' ...

ERROR: configuration failed for package 'RPostgreSQL'

* removing 'C:/Users/Hinata/Documents/R/win-library/2.13/RPostgreSQL'

 

Die heruntergeladenen Pakete sind in
#downloaded packages can be found in folder c:\users�

        �C:\Users\Hinata\AppData\Local\Temp\RtmpBsQJ05\downloaded_packages�

 

 

What can I do?

  

Cheers, Meike


	[[alternative HTML version deleted]]