AdventureWorks-for-Postgres
AdventureWorks-for-Postgres copied to clipboard
lorint
Set up the AdventureWorks sample database for use with Postgres
Not a bug, but a tip of the hat to @lorint : I was looking for a sizeable database on Postgres when I ran into this Pretty familiar with Adventureworks,...
As instruction says all csv files, install.sql and update_csvs.rb files in same folder. When ran "ruby update_csvs.rb" it only proceeded few files: ``` Processing ./BusinessEntity.csv Processing ./JobCandidate.csv Processing ./EmailAddress.csv Processing...
I am on a Mac. I have everything installed. From Terminal, when I run the psql commands, it asks for my password which I type in but it fails. The...
Attempting to connect with the [`docker` user](https://github.com/lorint/AdventureWorks-for-Postgres/blob/master/install.sh#L5) throws: > The server requested password-based authentication, but no password was provided. I've added a `WITH PASSWORD` statement to pull the `DOCKER_PASSWORD` environment...
The following error appears when executing install.sql ERROR: insert or update on table "productreview" violates foreign key constraint "FK_ProductReview_Product_ProductID" DETAIL: Key (productid)=(709) is not present in table "product".
Thank you for bringing this great data set to Postgres! I created a docker image using your instructions, but it failed. The fix was rather simple and is in the...
it has an error when importing csv file because of incorrect work directly . fixed with adding 'WORKDIR /data/' in docker file
- separated destination DB from container that connects and loads data - separated Ruby runner container from DB image. Now all images are separete and pure as they come from...
Hello, I have used files and scripts to setup AdventureWorks for postgres localy but when i run **psql -U postgres -d Adventureworks < D:/pgadmin/AdventureWorks-for-Postgres-master/install.sql** it created database schema but every...
