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

btj@havleik.no
-----------------------------------------------------------------------------------------------
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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Thu, 05 Jun 2008 15:28:55 +0200
Tino Wildenhain <tino@wildenhain.de> wrote:

> Hi,
>
> Bjørn T Johansen wrote:
> > 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....
> >
>
> 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