Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I compare sql create script with running database? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: How can I compare sql create script with running database?
Date
Msg-id 20080605134413.64606c8d@btj-laptop.asp-as.no
Whole thread Raw
In response to Re: How can I compare sql create script with running database?  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: How can I compare sql create script with running database?
List pgsql-general
Tree view 
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 by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: How can I compare sql create script with running database?
Next
From: "Albe Laurenz"
Date:
Subject: Re: how to sync the system table with pg_dump