#!/bin/sh
export PGPASSWORD=PYnuOIXNbkVOvdTL
P="psql -h 127.0.0.1 -U bgar1_delta_com -d bgar1_delta_com_ingredi"
echo "== tables with prov/mech/dir"
$P -tA -c "select table_name from information_schema.tables where table_schema='public' and table_name ~ 'prov|mech|dir|ldap' order by 1"
echo "== all tables s-z"
$P -tA -c "select table_name from information_schema.tables where table_schema='public' and table_name >= 's' order by 1" | tr '\n' ' '
echo
echo "== db.conf"
cat /home/bgar1_delta_com/ingredi-24.2.4/config/db.conf 2>/dev/null
echo "== db.connect"
cat /home/bgar1_delta_com/ingredi-24.2.4/config/db.connect 2>/dev/null
echo "== aa_wtest"
cat /home/bgar1_delta_com/ingredi-24.2.4/config/aa_wtest.conf 2>/dev/null
