[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...
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!
More information about the R-help
mailing list