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

[R] RODBC and PosgreSQL problems

2014-05-31 Thread Paul Gilbert
ately after the table name, or if you put a ; after the table name? (BTW, you will probably get better responses to this sort of question on the r-sig-db mailing list.) Paul Message: 23 Date: Fri, 30 May 2014 18:00:06 + From: "Fraser D. Neiman" To:"r-help@r-project.org"

Re: [R] RODBC and PosgreSQL problems

2014-05-31 Thread Frede Aakmann Tøgersen
Oprindelig meddelelse Fra: "Fraser D. Neiman" Dato:30/05/2014 21.27 (GMT+01:00) Til: r-help@r-project.org Emne: [R] RODBC and PosgreSQL problems Dear All, I am trying for the first time to run SQL queries against a remote PostgreSQL database via RODBC. I am able to establish a

[R] RODBC and PosgreSQL problems

2014-05-30 Thread Fraser D. Neiman
Dear All, I am trying for the first time to run SQL queries against a remote PostgreSQL database via RODBC. I am able to establish a connection just fine, as shown by getting results back from the sqlTables(), sqlColumns() and sqlPrimary Key() functions in RODBC. However, when I try to run a