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!
______________________________________________
R-help@r-project.org 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.
