Shell Script to compare row counts between two Greenplum Postgresql Database

This shell script takes 3 arguments: source db, target db and a list file of tables. List file is in format:$ cat listfile.lstschema.table : where<> ::schema2.table2 : where<> :: Also ~/gpdbinfo.dat file contains database name, host and port details. Below is the script to send the report file generated above as email :

Design a site like this with WordPress.com
Get started