#!/bin/bash

docker stop pg
docker rm pg
docker run --name=pg -e POSTGRES_HOST_AUTH_METHOD=trust -e POSTGRES_PASSWORD='' -p 5432:5432 -d postgres:13

sleep 5s # wait for PG to start

psql -h localhost -U postgres <<EOF
create database dev;
create user foo;
revoke all on database dev from public;
grant connect on database dev to foo;
revoke all on schema public from public;
EOF

psql -h localhost -U foo dev <<EOF
create table test_table(id int);
EOF