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

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: rod(at)iol(dot)ie
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can I compare sql create script with running database?
Date: 2008-06-05 11:44:13
Message-ID: 20080605134413.64606c8d@btj-laptop.asp-as.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 05 Jun 2008 11:06:36 +0100
Raymond O'Donnell <rod(at)iol(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-06-05 12:02:23 Re: how to sync the system table with pg_dump
Previous Message Raymond O'Donnell 2008-06-05 10:06:36 Re: How can I compare sql create script with running database?