R and SQL - How to join a data.frame in R with a table in SQL?

Asked

Viewed 26 times

1

I have a table in Postgresql that contains the column "cnae".

I also have a data.frame in the R with columns "cnae" and "Description".

I need to move the "Description" column up to the table in Postgresql by combining "cnae". Type a left_join().

I can’t find how to do this. Can anyone help me ?

I have this data.frame on an arch .csv. But also do not know how to climb to Postgresql and do right there.

sql r postgresql join
  • 1

    To select a table for the bank is enough dbWriteTable(con, "nome_que_tera_no_banco", objeto_no_R)

No answers

Browser other questions tagged sql r postgresql join

You are not signed in. Login or sign up in order to post.