Re: [R] RODBC and schemas

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

Duncan Golicher writes:

> 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?

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
| * * *
| - It's hard to live in the mountains, hard but not hopeless!

______________________________________________ mailing list
PLEASE do read the posting guide
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 Please read the posting guide before posting to the list.

list of date sections of archive