How to import csv files to postgreSQL?

 

How to import csv files to postgreSQL?

Create the data base

Create table sales_data(Order_id int,

Order_date date,

Customer_Id varchar,

City varchar,

Product_Id varchar,

Cupcake_Flavor varchar,

Quantity int,

Unit_Price float,

Rating int);

 

Copy sales_data from ‘C:\Program Files\PostgreSQL\Sales_data\ Sales_data.csv’ csv header;

 Select * from sales_data;