SQL

docker postgres create database

$ docker exec -it my_postgres psql -U postgres -c "create database my_database"

docker create postgresql database

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

how to recreate postgres database in docker

docker compose down
docker compose up --force-recreate

docker create postgres db

# inside Dockerfile
COPY your_sql_file.sql /docker-entrypoint-initdb.d/