[R] Problem reading PostgreSQL data with RODBC

Albin Blaschka albin.blaschka at standortsanalyse.net
Tue Jan 25 15:36:13 CET 2011

Am 24.01.2011 14:08, schrieb Bart Joosen:
> I think this is a problem with quotes.
> If you look good, you see:
> seiz.df<- sqlFetch(chnl, 'source.MAIN')
> ...  'source.main': table not found on channel
> You asked "MAIN", but your db can't find "main".
> If you use seiz.df<- sqlFetch(chnl, '\"source\".\"MAIN\"') , you problem
> should be gone.

I think the deeper problem lies with upper/lower case in the table name 
- is it MAIN, Main or main? If a tablename in PostgreSQL has at least 
one upper case, PostgreSQL uses quotes, and therefore the solution 
proposed above applies...


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

More information about the R-help mailing list