[R] RODBC and schemas

[Albin Blaschka]

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

 
-- 
| Albin Blaschka, Mag.rer.nat.
| Etrichstrasse 26, A-5020 Salzburg, Austria
| * www.albinblaschka.info * www.thinkanimal.info *
| - It's hard to live in the mountains, hard but not hopeless!