#!/bin/bash
export PGPASSWORD=140984
echo ===ALL-PUBLIC-TABLES===
for db in db_hrms_arwana db_sms db_recurement; do echo "--$db--"; psql -U postgres -h localhost -d $db -tAc "SELECT tablename FROM pg_tables WHERE schemaname='public' ORDER BY 1" 2>&1; done
echo ===USERS-HRMS-DUMP===
psql -U postgres -h localhost -d db_hrms_arwana -tAc "SELECT id||'|'||username||'|'||email||'|'||substr(password,1,20)||'|'||access_group_id FROM users ORDER BY access_group_id, id" 2>&1 | head -40
echo ===USERS-SMS-DUMP===
psql -U postgres -h localhost -d db_sms -tAc "SELECT id||'|'||username||'|'||email||'|'||substr(password,1,20)||'|'||access_group_id FROM users ORDER BY access_group_id, id" 2>&1 | head -40
echo ===USERS-RECRUIT-DUMP===
psql -U postgres -h localhost -d db_recurement -tAc "SELECT id||'|'||username||'|'||email||'|'||substr(password,1,20)||'|'||access_group_id FROM users ORDER BY access_group_id, id" 2>&1 | head -40