creating and connecting to a postgresql database with docker code example

Example 1: connect to postgres database in docker container

$ docker exec -it postgres-container psql -U postgres

Example 2: docker create postgres db

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