Skip to content

sethjholl07/adventure-works-postgres

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 

Repository files navigation

AdventureWorks for Postgres

This is based off the work done by lorint. We've already done the work to convert the csv's to be compatible with postgres. If you would like the original files, head over to Adventure Works 2014 OLTP download page. The download includes a script for loading the data into MSSQL Server.

Getting started

First, make sure you have postgres installed. You can do this by typing psql in terminal.
If nothing comes up, install postgres using brew install postgres. This will install and initialize a postgres database.

Windows

Head over to https://www.postgresql.org/download/windows/ and follow the instructions.

Run the script

Once you have confirmed your postgres install, run the following two lines:

psql -c "CREATE DATABASE \"Adventureworks\";"
psql -d Adventureworks < install.sql

You're all set!

About

Adventureworks OLTP for training, tutorials

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PLpgSQL 100.0%