Thread:

<div class="Section1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Dear pgAdmin
support,</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Courier New"">Is there an easy way to compare two
db,structureand data, early equals?</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier
New"">Iuse pgAdmin III 1.8.4</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier
New""> </span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Courier New"">Thanks in adavnace for your help</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Courier New""> </span><p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif"">Best Regards</span><p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""> </span><p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif"">gianfranco</span><p class="MsoNormal"> </div> 

Le 27/01/2010 15:11, Gianfranco Giacomini a écrit :
> [...]
> Is there an easy way to compare two db,structure and data, early equals?
> 
> I use pgAdmin III 1.8.4
> 

Not with pgAdmin.

But you can use check_postgres (http://bucardo.org/check_postgres) to
compare two database schemas.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com

> Le 27/01/2010 15:11, Gianfranco Giacomini a écrit :
> > [...]
> > Is there an easy way to compare two db,structure and data, early equals?
> >
> > I use pgAdmin III 1.8.4
> >
>
> Not with pgAdmin.
>
> But you can use check_postgres (http://bucardo.org/check_postgres) to
> compare two database schemas.
>
Another tool, but based on java:
http://apgdiff.sourceforge.net/

"Another PostgreSQL Diff Tool is simple PostgreSQL diff tool that is useful for schema upgrades. The tool compares two
schemadump files and creates output file that is (after some hand-made modifications) suitable for upgrade of old
schema."

Best regards