On Thu, 05 Jun 2008 15:28:55 +0200 Tino Wildenhain <tino@xxxxxxxxxxxxx> wrote: > 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 > That I could do.... :) BTJ
