[R] Problem reading PostgreSQL data with RODBC

Bart Joosen bartjoosen at hotmail.com
Mon Jan 24 14:08:18 CET 2011

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.


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.

More information about the R-help mailing list