# Use the official PostgreSQL image FROM postgres:latest # Set build-time variables ARG DB_USER ARG DB_PASSWORD ARG DB_DATABASE ARG POSTGRES_PASSWORD # Set environment variables ENV POSTGRES_USER=$DB_USER ENV POSTGRES_PASSWORD=$DB_PASSWORD ENV POSTGRES_DB=$DB_DATABASE # Copy your SQL scripts from the root directory COPY ./sql/ /docker-entrypoint-initdb.d/ # Add a script to create the database in the correct order COPY ./import-sql.sh /docker-entrypoint-initdb.d/ # Grant execution permissions to the script RUN chmod +x /docker-entrypoint-initdb.d/import-sql.sh