'How do I import CSV dataset to relation database?

So, I am using postgreSQL.

I got data set in csv file. It contains data in format like this: "ID", "name", "surname","adress", "company", "position", "companyAdress" ---And all of data is below this header

Now I created relation tables, one being employeeInfo, and another companyInfo

employeeInfo

ID PK int name varchar surname varchar adress varchar

companyInfo

companyID PK int company varchar position varchar companyAdress varchar employeeID int FK of employeeInfo

How can I import my normal dataset into this relation DB, considering I just created companyID, and did not have it before. Should I first make querys that will export data i need from my original dataset? What do I do with company ID in this case?

sqlpostgresqlrelational-database


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