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

--

--

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
thejasmine

thejasmine

📍San Francisco, CA| Business Analytics | Strategy | Payments | https://thejasminehuang.com