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 [EMAIL PROTECTED]) > > > > > > > > -- > Bruno LEVEQUE > System Engineer > SARL NET6D > [EMAIL PROTECTED] > http://www.net6d.com > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > > Yuji Shinozaki Computer Systems Senior Engineer [EMAIL PROTECTED] Advanced Technologies Group (434)924-7171 Information Technology & Communication http://www.people.virginia.edu/~ys2n University of Virginia ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
