[R] Problem reading PostgreSQL data with RODBC

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

Bart

-- 
View this message in context: http://r.789695.n4.nabble.com/Problem-reading-PostgreSQL-data-with-RODBC-tp3232706p3233977.html
Sent from the R help mailing list archive at Nabble.com.