![Example of running the program](example.png?raw=true)
- Create the news database in PostgreSQL
- From the command line, launch the psql console by typing: psql
- Check to see if a news database already exists by listing all databases with the command:
- If a news database already exists, drop it with the command: DROP DATABASE news;
- Create the news database with the command: CREATE DATABASE news;
- exit the console by typing: \q
- From the command line, navigate to the directory containing newsdata.sql.
- Import the schema and data in newsdata.sql to the news database by typing:
psql -d news -f newsdata.sql
- Once the news database has been set up, from the command line navigate to the directory containing analyzer.py.
- Run the script by typing: