Containerized PostgreSQL client for executing SQL commands in containerized environments

The psql-client image is stored on Docker Hub in the rtdl/psql-client repository.

This is a sub-project of rtdl – the real-time data lake. Please go to rtdl's repo and give it a star.

This image is not interactive and has no default ENTRYPOINT. You can use the entrypoint option to execute psql commands and volumes to load scripts that can be executed with the psql client.

docker run --name psql-client \
-v ${PWD}/catalog/scripts/create-user-db.postgres.sql:/create-user-db.postgres.sql \
--entrypoint psql \
rtdl/psql-client:latest \
-h dbhost -p 5433 -U postgres -f /create-user-db.postgres.sql

psql-client:
  image: rtdl/psql-client:latest
  container_name: psql-client
  volumes:
    - ./catalog/scripts/create-user-db.postgres.sql:/create-user-db.postgres.sql
  entrypoint: psql -h dbhost -p 5433 -U postgres -f /create-user-db.postgres.sql

If you want to build the image yourself, clone the repo and run docker build -t rtdl/psql-client:latest ..