Shridhar Daithankar wrote:
>
> Do a pg_dump -s on both the databases to produce their schemas. Then diff
> those two schemas to find out anything is missing.
I forgot to mention that the test db was created this way:
- on the live db do a pg_dump TAL > dump
- copy dump file to test database server
- on the test db do a createdb TEST; psql TEST < dump
This way the two dbs will have the schemas no?
Thanks,
Jean-Christian Imbeault