How to append an existing postgresql database table with a new data frame

[varma.a...@gmail.com]

Hi,

I wanted to append the existing postgresql table structure and data with a new data frame. How to do this?

Need some suggestions.

Thanks and Regards,
Ravi Varma Alluru.

[Gabor Grothendieck]

> I wanted to append the existing postgresql table structure and data with a new data frame. How to do this? 

If X is an existing table in your PostgreSQL database and Y is a data.frame in your R workspace with the same column names then this will insert Y into X:

   library(sqldf)

   library(RPostgreSQL)

   sqldf("insert into X select * from Y")

although typically if you want to manipulate existing tables in a database one would use RPostgreSQL directly.