rtdl/psql-client repository overview

⁠psql-client

Containerized PostgreSQL client for executing SQL commands in containerized environments

The psql-client repo is stored on GitHub in the realtimedatalake/psql-client-docker repository⁠.

⁠Use

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 example

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

Docker Compose example

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

⁠Build

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