Setup
sudo -u postgres psql postgres
- You might want to set up a user account for yourself
- The default user is
postgres
- Helpful Links:
- Connect using
pgAdmin
Loading new data
- Create a new database called
imdb
- Right-click on
imdb
, select Restore...
- Find
imdb.backup
- Should now have four
table
s in the public
schema
cast_info
movies
people
role_type
- aside:
DATABASE
vs. SCHEMA