Sign inSign up

lombardo/postgresql-exercises-docker

By lombardo

•Updated 11 months ago

Dockerized PG instance containing the dataset from https://pgexercises.com/

Image
0

384

lombardo/postgresql-exercises-docker repository overview

⁠postgresql-exercises-docker

A Dockerized version of the Postgres Database used by https://pgexercises.com/⁠.

⁠How to use

$ docker run -d -p 5432:5432  \
	-e "POSTGRES_USER=postgres" \
	-e "POSTGRES_PASSWORD=postgres" \
	lombardo/postgresql-exercises-docker:0.0.1

$ psql -h localhost -p 5432 -U postgres -W exercises

exercises=# select * from cd.facilities;

⁠Dockerhub

https://hub.docker.com/r/lombardo/postgresql-exercises-docker/⁠

⁠Todo

  • drop the cd schema after every operation and recreate it, to allow for data modification exercises

⁠Credits

The original PostgreSQL Exercises website and dataset was made by Alisdair Owens⁠ under CC BY-SA 3.0⁠.

Tag summary

Content type

Image

Digest

sha256:56695492d…

Size

153.6 MB

Last updated

11 months ago

docker pull lombardo/postgresql-exercises-docker:1.0.0