create a postgres database docker code example
Example 1: docker postgres
$ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgres
Example 2: connect to postgres database in docker container
$ docker exec -it postgres-container psql -U postgres
Example 3: docker create postgres db
# inside Dockerfile
COPY your_sql_file.sql /docker-entrypoint-initdb.d/