current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise
up vote 1 down vote favorite

I am using RPostgreSQL package to connect the db to R. I wanted to update the db with those tables do not exist in db. Is it possible to create the new table from R in postgresql and update it with upcoming values? Any suggestion?

Sample of data:


       Date&Time               temp
1 2007-09-30 00:00:00 -0.1153333
2 2007-09-30 01:00:00 -0.4006667
3 2007-09-30 02:00:00 -0.4493333
4 2007-09-30 03:00:00 -0.7540000
5 2007-09-30 04:00:00 -0.5783333
6 2007-09-30 05:00:00 -0.3280000
share|improve this question
    
Have you looked at dbWriteTable from the package? See this question – Justin Jan 7 '13 at 17:35
    
Yes, I have tried it but I came up with this error: Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbWriteTable", for signature "PostgreSQLConnection", "character", "POSIXct" – f.ashouri Jan 7 '13 at 17:40
3  
if you provide some of the code you've used and the error message as well as str(yourdata) you will get a much better answer. Currently, any answer would be a shot in the dark. – Justin Jan 7 '13 at 17:50
up vote 2 down vote

We added a number of tests for automatic conversion of types to the package, see the source tarball. In particular, the conversion of SQL Datetime to POSIXct was a prime motivation for me to get the package started (as a GSoC project).

But we may simply not writing back the same way you did here. So if it complains about a missing converter for POSIXct, try converting the POSIXct column(s) to numeric, and then provide a reproducible example on the rpostgresql mailing list (see the code.google.com repo and wiki).

share|improve this answer
up vote 0 down vote

To Create a table, you need the dbSendUpdate() function.

require(rjdbc)
...
dbSendUpdate(conn, "CREATE abc (...)")
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.