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!