Обсуждение:

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