Run a postgres db really quick in a docker container (cmd)

_run_postgres_in_docker.cmd

docker network create -d bridge internal-network

docker pull postgres
docker run --network=internal-network --name postgres-db --publish 5432:5432 -e POSTGRES_PASSWORD=root -d postgres

If you compose your other containers with this option in the docker-compose.override.yml or docker-compose.yml file:

networks:
    default:
        external: true
        name: internal-network

Your connection string from within another docker container (which accesses the db from this new container) will be:

"Host=host.docker.internal;Port=5432;Database=database;Username=postgres;Pwd=root;"
Your connection string from "outside" aka the host machine (with pgAdmin) will be:

"Host=127.0.0.1;Port=5432;Database=postgres;Username=postgres;Password=root;"