[R] RODBC and schemas

Albin Blaschka
2008-05-05T18:40:18Z

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!