'RPostgreSQL populating database with CSV and adding primary key column

I have started using Postgres and RPostgreSQL. I have manually created a server and database in the Postgres. Now I want to populate the database with my existing CSV files. The additional step would be adding a primary key column with incrementing numbers. I know how to do these in pgAdmin. Is there a way to do all these in R?

rpostgresqlcsvpopulaterpostgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions