Re: How can I compare sql create script with running database?

Поиск
Список
Период
Сортировка
От Bjørn T Johansen
Тема Re: How can I compare sql create script with running database?
Дата
Msg-id 20080605134413.64606c8d@btj-laptop.asp-as.no
обсуждение исходный текст
Ответ на Re: How can I compare sql create script with running database?  (Raymond O'Donnell <rod@iol.ie>)
Ответы Re: How can I compare sql create script with running database?  (Tino Wildenhain <tino@wildenhain.de>)
Список pgsql-general
Дерево обсуждения 
On Thu, 05 Jun 2008 11:06:36 +0100
Raymond O'Donnell <rod@iol.ie> wrote:

> On 05/06/2008 10:52, Bjørn T Johansen wrote:
> > If I already have a running database, how can I compare the tables in
> > the database with the sql script to discover the differences?
>
> You can use pg_dump with the -s option to dump the schema of the
> database, and run it through the diff tool of your choice.
>
> Ray.
>

Well, not really an option because I don't think the dump will be an exact match to the sql script....

BTJ

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: How can I compare sql create script with running database?
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: how to sync the system table with pg_dump