Setup
sudo -u postgres psql- 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
tables in the public schema
cast_infomoviespeoplerole_type
- aside:
DATABASE vs. SCHEMA