Skip to content

RPostgreSQL dbWriteTable

1 message · Chris Long

#
Hi,

RPostgreSQL's dbWriteTable uses the technique of saving a temporary
file, then loading the temporary file to a table using "COPY ... FROM".
This is fine for a local database connection, but fails if you are connected
to a remote database.  A simple fix is to use a technique similar to either
RSQLite or ROracle.  I've sent a note to the authors.

I'm *really* happy to see this available; it's a tremendous improvement
over the existing (and unmaintained) connectivity packages.  Kudos
to the authors as well as Google for its support.