dpsql
373 bytes
1# vim: ft=zsh
2# connect to dune RDS instance
3
4if (( $# < 2 )); then
5 echo "usage: dpsql <env> <db> [pgcli options...]" >&2
6 return 1
7fi
8
9env=${1}
10db=${2}
11shift 2
12PGPASSWORD=$(aws secretsmanager get-secret-value --secret-id ${env}_${db}_db_${db}_user_password --output text --query SecretString) pgcli --less-chatty $@ -U ${db} -h ${env}-${db}-db.ayu-decibel.ts.net ${db}