#!/bin/bash
set -euo pipefail
set -a
source /srv/sub2api-80/releases/release_20260322_011911_v0105/sub2api.env >/dev/null 2>&1
set +a
export PGPASSWORD="$DATABASE_PASSWORD"
psql -h "$DATABASE_HOST" -p "$DATABASE_PORT" -U "$DATABASE_USER" -d "$DATABASE_DBNAME" -Atc "select table_schema||'.'||table_name from information_schema.tables where table_schema not in ('pg_catalog','information_schema') and (table_name ilike '%progress%' or table_schema ilike '%progress%') order by 1;"