Create Database in PostgreSQL

Starting with the simple data model we will create the necessary database and users in the postgreSQL database.  The PGAdmin client (https://www.pgadmin.org/) is a nice GUI for the database that allows us to create new databases, tables, and users.

1. create DB

2. create users

3. add privileges for the users

All posts in this ETL series:
Install PostgreSQL Database
Simple Data Model
Create Tables in PostgreSQL Database
Getting JSON API data with Python
Inserting JSON data into Postgres with Python