#!/usr/bin/env bash # psql.sh [psql args…] — interactive psql (or -c/-f) inside the postgres container on the data node. # psql.sh interactive shell on dci # psql.sh -c 'select count(*) from facilities' # psql.sh -d dci_restore source "$(dirname "${BASH_SOURCE[0]}")/lib.sh" tty_flag="-t"; [[ -t 0 ]] || tty_flag="-T" extra=""; [[ $# -gt 0 ]] && extra="$(printf '%q ' "$@")" exec ssh -t "${SSH_OPTS[@]}" "$(host_for data)" "$(compose_prefix data) exec $tty_flag postgres psql -U dci -d dci $extra"