I am currently following a PostgreSQL course on Udemy, and I've hit a roadblock with the setup. I downloaded the dvdrental.tar resource file, but I can't figure out how to load the tables into my database.
The download is usually a .zip file ( dvdrental.zip ). You must extract this to get the dvdrental.tar file. dvdrental.tar udemy
Thousands of rows of realistic data representing movies, actors, customer transactions, and payments. I am currently following a PostgreSQL course on
Don't try to unzip it like a normal folder. This is a pg_dump archive. You need to create a blank database first in pgAdmin, then right-click and use the function (not "Import") to load the data. Once you get it running, it’s a fantastic dataset for practicing Joins and Subqueries! You must extract this to get the dvdrental
: Open pgAdmin, right-click on Databases , select Create > Database , and name it dvdrental .
pg_restore --dbname=dvdrental --clean --if-exists --no-owner dvdrental.tar
Her tip gets 50 upvotes and saves dozens of students hours of confusion.