Re: [R] RODBC and PosgreSQL problems

2014-06-04 Thread Fraser D. Neiman
Dear All, I just wanted to follow up my question with an answer, which I owe to Robbie Bingler at UVA's IATH. The code chunk that bombed is here: sqlQuery(DRCch,paste(" + SELECT * + FROM tblCeramicWare + ")) [1] "42P01 7 ERROR: relation \"tblceramicware\" does not exis

Re: [R] RODBC and PosgreSQL problems

2014-05-31 Thread Frede Aakmann Tøgersen
Hi Not sure was is going on! Can you try to do the sqlQuery without the paste function? Like this: sqlQuery(DRCch,"SELECT * FROM tblCeramicWare")) By the way your sqlTables doesn't list the tblCeramicWare table. Br. Frede Aakmann Tøgersen Sendt fra Samsung mobil Oprindelig medde