Re: [GENERAL] How can I compare sql create script with running database?
On Thu, 05 Jun 2008 15:28:55 +0200 Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Hi, > > Bjørn T Johansen wrote: > > On Thu, 05 Jun 2008 11:06:36 +0100 > > Raymond O'Donnell <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How can I compare sql create script with running database?
Hi, Bjørn T Johansen wrote: On Thu, 05 Jun 2008 11:06:36 +0100 Raymond O'Donnell <[EMAIL PROTECTED]> 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 smime.p7s Description: S/MIME Cryptographic Signature
Re: [GENERAL] How can I compare sql create script with running database?
On Thu, 05 Jun 2008 11:06:36 +0100 Raymond O'Donnell <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How can I compare sql create script with running database?
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. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How can I compare sql create script with running database?
If I already have a running database, how can I compare the tables in the database with the sql script to discover the differences? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" --- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
