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

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.✨



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


📍San Francisco, CA| Business Analytics | Strategy | Payments |