How we can write data to a postgres DB table using R?

Question

I need to write data to a postgres DB table using R. If a data exist for an ID in the table, data should be updated otherwise new data should append to the table.

I tried this using 'RPostgreSQL' Package I got this error message

dbWriteTable(con, 'credit', credit,overwrite=TRUE,row.names=FALSE,append=TRUE)<br>

Error in postgresqlWriteTable(conn, name, value, ...) :overwrite and append cannot both be TRUE

Manura Omal · Accepted Answer · 2015-09-09 05:09:35Z

3

You cannot use overwrite and append at once. If use overwrite command as follows, it will truncate the table and rewrite the data.

dbWriteTable(con, 'credit', credit,overwrite=TRUE,row.names=FALSE)

If use append it will Add the rows. But it won't update your results.

dbWriteTable(con, 'credit', credit,row.names=FALSE,append=TRUE)

answered Sep 9, 2015 at 5:09

Manura Omal

1,0553 gold badges11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

captainpete Over a year ago

Note that overwrite=TRUE drops and recreates the table rather than truncating.

Collectives™ on Stack Overflow

How we can write data to a postgres DB table using R?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related