mtv_test.sh

application/x-shellscript

Filename: mtv_test.sh

Type: application/x-shellscript

Part: 1

Message: Statistics import and export: difference in statistics of materialized view dumped

dropdb postgres
dropdb rdb
createdb postgres
createdb rdb
psql -d postgres -f mtv_test.sql
pg_dump -d postgres | psql -d rdb 
pg_dump -d postgres > /tmp/pgdb.out
pg_dump -d rdb > /tmp/rdb.out
diff /tmp/pgdb.out /tmp/rdb.out