[R] RODBC and schemas

Duncan Golicher
2008-05-05T20:50:36Z

Many thanks Albin,

Problem solved. This works fine for me now.

library(RODBC)
con<-odbcConnect("mydb")
odbcQuery(con,"SET search_path =meso, pg_catalog;")
d<-sqlFetch(con,"trees")
sqlSave(d,"trees2")

Duncan

Albin Blaschka wrote:
> Duncan Golicher writes:
>
> [snip]
>> thread that I found led to an obvious solution. Brian Ripley pointed
>> out the issue with the dot syntax and suggested that "you can set
the
>> schema and then use unqualified names." Does anyone know how this
can
>> be done for postgresql?
> [snip]
>
> The SQL-Syntax for this is:
> SET search_path = schemaname, anotherschema, pg_catalog;
>
> So, you have to pass this to postgres beforehand...
> Remark: pg_catalog is necessary, it is needed for general, built-in
> functions of postgres
>
> Hope that helps,
>
> Greetings, Albin
>
>


--
Dr Duncan Golicher
Conservaci?n y Restauraci?n de los bosques de Chiapas
Ecolog?a y system?tica terrestre
Conservaci?n de la Biodiversidad
El Colegio de la Frontera Sur
Carretera Panamericana y Perif?rico Sur s/n
29290 San Crist?bal de las Casas, Chiapas
967 67 49000 ext 1310

Email:  dgoliche at ecosur.mx
Skype: duncangolicher
WebLog http://duncanjg.wordpress.com/

Using Thunderbird on Ubuntu Hardy 8.04