Skip site navigation (1) Skip section navigation (2)

Re: compare two databases

From: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>
To: Ashok Chauhan <ashok(at)kalculate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: compare two databases
Date: 2003-11-16 14:09:10
Message-ID: 3FB78506.9080509@net6d.com (view raw or flat)
Thread:
Lists: pgsql-admin
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



In response to

Responses

pgsql-admin by date

Next:From: Yuji ShinozakiDate: 2003-11-16 14:46:08
Subject: Re: compare two databases
Previous:From: Ashok ChauhanDate: 2003-11-16 13:14:08
Subject: compare two databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group