Re: compare two databases

Here's a question about that: Do dumps always occur
in a predictable row order?

If it is not the case, then you might need to sort each
table dump before the diff.

yuji
----

On Sun, 16 Nov 2003, Bruno LEVEQUE wrote:

> Maybe you can use :
>
> pg_dump -s -t Thetable firstdatabasename > first
> pg_dump -s -t Thetable seconddatabasename > second
>
> diff first second
>
>
>
> Bruno
>
>
> Ashok Chauhan wrote:
>
> >there is any utility or command for compare two databases,
> >tables structure (schema).
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> >
> >
>
> --
> Bruno LEVEQUE
> System Engineer
> SARL NET6D
> bruno(dot)leveque(at)net6d(dot)com
> http://www.net6d.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

Yuji Shinozaki Computer Systems Senior Engineer
ys2n(at)virginia(dot)edu Advanced Technologies Group
(434)924-7171 Information Technology & Communication
http://www.people.virginia.edu/~ys2n University of Virginia