Hi,
I just got started with R. I am trying to load some data into PostgreSQL
using RPostgreSQL. Everything went quite smoothly except for that the table
created by using dbWriteTable does not have a primary key.
The ideal solution is to ask PostgreSQL to do a auto-increment with the
rows I am going to load into the table so I don't have to manually generate
a primary key column in the data frame.
Does anybody know how to do this?
Many thanks.
Bill
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.