Connect to PostgreSQL CLI

psql

Display databases

\l

Create database

create database dvdrental;

Load installed database dvdrental

# this is in shell, not in psql cli
pg_restore -U <username> -d dvdrental <location>/dvdrental

Connect to database

\c dvdrental

Display all tables in database

\dt

Query table

selct * from customer;

Quit PostgreSQL CLI

\q