Обсуждение: compare database

Поиск
Список
Период
Сортировка

compare database

От
Sindu
Дата:
Hi all,

Is there any script to compare 2 database schema? (not the content, but
the structure).

I tried using "pg_dump -s" and comparing the resulting text file,
unfortunately it seems pg_dump is dumping the tables in OID order
(CMIIW), so the text file output might not be the same depending on the
table creation order.

I've searched the FAQ and contrib, and couldn't find any. I think this
should be in FAQ.

Thanks in advance and best regards,
Sindu