[R] Problem reading PostgreSQL data with RODBC

[Albin Blaschka]

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

HTH,
Albin

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