Postgres Pro
Downloads
Home   >   mailing lists

Re: compare two databases - Mailing list pgsql-admin

From Bruno LEVEQUE
Subject Re: compare two databases
Date
Msg-id 3FB78506.9080509@net6d.com
Whole thread Raw
In response to compare two databases  (Ashok Chauhan <ashok@kalculate.com>)
Responses Re: compare two databases  (Yuji Shinozaki <ys2n@virginia.edu>)
List pgsql-admin
Tree view 
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@postgresql.org)
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com

pgsql-admin by date:

Previous
From: Ashok Chauhan
Date:
Subject: compare two databases
Next
From: Yuji Shinozaki
Date:
Subject: Re: compare two databases