Re: Schema comparisons

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Schema comparisons
Дата
Msg-id 25377.1077942505@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Schema comparisons  (Mark Lubratt <mark.lubratt@indeq.com>)
Список pgsql-admin
Mark Lubratt <mark.lubratt@indeq.com> writes:
> I've been trying to be careful, but I've gotten out of synch with
> whether or not I've applied the changes I've made to the development
> system to the production system.  Is there a utility that will compare
> the tables, functions, trigger, views, etc. between two systems and
> flag the schema elements that aren't in synch between the two?

Have you tried diffing pg_dump output?  It's not the greatest tool but
it's helpful.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mark Lubratt
Дата:
Сообщение: Schema comparisons
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: ALTER table taking ages...