No description, website, or topics provided.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md
SQL_Presentation_Final.pptx
restaurant_db.sql
transact.txt

README.md

Postico download: (Mac-specific, but there are other GUIs for Windows) https://eggerapps.at/postico/

Setup instructions: https://eggerapps.at/postico/docs/v1.1.1/

Chinook db script: https://raw.githubusercontent.com/xivSolutions/ChinookDb_Pg_Modified/master/chinook_pg_serial_pk_proper_naming.sql

After downloading Postgresql you will have access to the command line tool.

Open the terminal.

Type psql to enter the postgresql command line tool.

Type create database <db_name>; to create a new database that will be loaded from each data file (restaurant_db.sql and transact.txt)

For example

create database restaurant_db;

create database transactions;

Now exit the Postgres command line tool by typing \quit

To add the "dump" files to your empty databases use the following commands

psql restaurant_db < restaurant_db.sql

psql transactions < transact.txt

You should see a list of commmands flash over the terminal. This means that the data was added.

Now try to do a simple select statement to access your data

psql transactions

Now you've entered the psql commmand line tool and should see a prompt starting with "transactions=#"

Type select * from customers; You should see the contents of this table printed to the terminal. Now you're ready to start querying!

**And remember, control+C does not work to exit the psql command line tool in the terminal, you must type \quit or close the terminal window.