Re: [R] RODBC and schemas

From: Albin Blaschka <albin_at_albinblaschka.info>
Date: Mon, 05 May 2008 20:40:18 +0200

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_at_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.
Received on Mon 05 May 2008 - 19:11:10 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 05 May 2008 - 21:30:38 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive