Problem reading PostgreSQL data with RODBC

Mon, Jan 24, 2011 5:08 AM

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.

Thread (5 messages)

Robert W. Burn Problem reading PostgreSQL data with RODBC Jan 23 stephen sefick Problem reading PostgreSQL data with RODBC Jan 23 Phil Spector Problem reading PostgreSQL data with RODBC Jan 23 Bart Joosen Problem reading PostgreSQL data with RODBC Jan 24 Albin Blaschka Problem reading PostgreSQL data with RODBC Jan 25