#!/bin/bash
# Postgresql schema comparer
# Copyright 2007 Svenne Krap
# Released under ASL 2.0

if [ $# -ne 2 ]; then
    echo "DB compare <db1> <db2>"
    exit
fi
DB1=$1
DB2=$2
File1=`mktemp`
File2=`mktemp`
echo "Compare PostgreSQL database $DB1 and $DB2"
echo "No lines below this means database structure is equal. Data is not checked."
pg_dump --schema-only $DB1 > $File1
pg_dump --schema-only $DB2  > $File2
diff -u $File1 $File2
rm $File1
rm $File2