Run Postgres Docker

run_docker-postgres.sh

#!/usr/bin/env bash

sudo docker run --name postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgres

wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
sudo apt-get update && sudo apt-get install -y dbeaver-ce


#EXAMPLE
sudo docker exec -it postgres psql -U postgres -c "create database store"

sudo docker cp schema.sql postgres:/tmp/schema.sql
sudo docker exec -it postgres psql -U postgres -d store -f /tmp/schema.sql

sudo docker cp data.sql postgres:/tmp/data.sql
sudo docker exec -it postgres psql -U postgres -d store -f /tmp/data.sql