How to import CSV file to pgAdmin🐘

Photo by Caspar Camille Rubin on Unsplash

For the demo, I am going to use olist dataset, a dataset of orders made at olist.com.

Import CSV file to pgAdmin

Create a database

create database

Create the order table and order payment table

Import CSV to tables

• Turn export to import
• Turn Header to Yes
• Select Delimiter ‘, ’

Check data

After importing data, we can start to write some queries.✨