How to import CSV file to pgAdminš
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 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.āØ