create docker container with postgres database 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/