postgreSQL in docker

postgreSQLinDocker.md

PostgreSQL with Docker AGENDA

1 : Create a Postgres docker container docker run --name demo -e POSTGRES_PASSWORD=password1 -d postgres

2: Connect and run some queries docker exec -it demo psql -U postgres

CREATE DATABASE demo_db1 \c demo_db1 CREATE TABLE demo_t(something int); INSERT INTO demo_t (something) VALUES (1);

3: Automate - run scripts using docker cli

• run sql scripts from your host machine/dev machine etc

docker run --name demo -v "$PWD"/:/opt/demo/ -e POSTGRES_PASSWORD=password1 -d postgres docker exec -it demo psql -U postgres -c "CREATE DATABASE demo_db2" docker exec -it demo psql -U postgres -f /opt/demo/script_demo1.sql