[R] rjdbc identifier.quote

Gabor Grothendieck ggrothendieck at gmail.com
Thu Feb 10 05:12:03 CET 2011


On Wed, Feb 9, 2011 at 11:05 PM, Armand Pirvu (gmail)
<armand.pirvu at gmail.com> wrote:
> Hi Gabor
>
> Thank you for your  reply
>
> I tried it
>
>> dbWriteTable(conn, "table6",mylargedata,identifier.quote ="\"")
> Error in .sql.qescape(names(value), TRUE, conn at identifier.quote) :
>  The JDBC connection doesn't support quoted identifiers, but table/column name contains characters that must be quoted (m.1997.09.01)
>
> Alas it still fails.
>
>
> The strange thing is that it appears to me that " is a valid identifier.quote in the DBMS. As I pointed out  I could run in via JDBC a create table tt ("m.1.2.4" integer) statement
>
> So I am a bit suspicious that maybe I hit a snag in RJDBC ?
>
>

There is no reason to think that that would work.  Its certainly not
what I had suggested.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list