Taking PostgreSQL Table Definition backup with their table File name

In this shell script will help you to take the backup of PostgreSQL table definition with different or individual file name as schema based.

# Config:
DB="DBA"
U=enterprisedb
export PGPASSWORD="tcs45"
export PGPORT="5444"
export PGHOST="20.0.4.101"

TABLES="$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t -c "SELECT table_name FROM
information_schema.tables WHERE table_schema='billing'")"
for table in $TABLES; do
  echo backup $table ...
/opt/edb/as9.6/bin/pg_dump -d $DB -U $U -w -st billing.$table > /home/Admin/2ndquadrant.in/HealthCraft_DC/schemas/billing/tables/billing.$table;
done;
cd /home/Admin/2ndquadrant.in/HealthCraft_DC/schemas/billing/tables
ls -lh
echo done

Note : Here billing is the schema name DBA is the database name so you can change the database and schema name as per your postgres table backup strategy.

FOR IT Related SUPPORT