6. Postgres Administration - Restore database - dvdrental

Download and restore dvdrental database in postgres
#Create dvdrental database
create database dvdrental

#quit from postgres instance
\q

#Download dvdrental backup file

#Install unzip
sudo apt install unzip
#Restore database

#connect to postgres instance
psql

#Change the database context to dvdrental
\c dvdrental

#List out tables
\dt

#select one row from actor table
select * from actor limit 1;