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

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

Hi,

Bjørn T Johansen wrote:
> On Thu, 05 Jun 2008 11:06:36 +0100
> Raymond O'Donnell <rod@xxxxxx> 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....

Unless you create all your objects with your script into a different 
Database on the server then use pg_dump -s on both and compare the
result :-)

Cheers
Tino

<<attachment: smime.p7s>>