Mac Categories

apgdiff 1.3


apgdiff Free PostgreSQL diff tool useful for schema upgrades

System Requirememts
Mac OS X
Download Details
Company Miroslav Sulc
Version 1.3
Post Date October 08, 2009
License Freeware
File Size 53 KB
There are no screenshots

apgdiff 1.3


Free PostgreSQL diff tool useful for schema upgrades
apgdiff is a free and Java based platform-independent PostgreSQL diff tool that is useful for schema upgrades.

The apgdiff tool compares two schema dump files and creates output file that can be used for upgrade of old schema.


Main features of apgdiff:

  • apgdiff looks for differences in definitions of TABLEs, SEQUENCEs, CONSTRAINTs, INDEXes, VIEWS, FUNCTIONs and TRIGGERs
  • apgdiff creates SQL commands for creations, drops and modifications of database objects
  • CREATE SCHEMA, CREATE TABLE, ALTER TABLE (except ALTER TABLE ... OWNER TO ...), CREATE SEQUENCE, CREATE INDEX, CREATE (OR REPLACE )VIEW, CREATE (OR REPLACE )FUNCTION, CREATE TRIGGER and SET search_path commands are supported but some specific features of the commands may not be implemented yet (see Note below)
  • Comments, empty lines, SET (except SET search_path), COMMENT, SELECT, INSERT INTO, REVOKE, GRANT and possibly other commands are ignored


    Requirements of apgdiff:

  • Java 5 or later