Re : pg_dump - schema diff compatibility

Hi,

May be a solution will be to make a diff fo the XML file produced by another tool: DdlUtils (http://db.apache.org/ddlutils/) !
However, DdlUtils won't produce a file with all PG elements (no user types, views, triggers, ...).

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Sualeh Fatehi <sualeh(dot)fatehi(at)gmail(dot)com>
À : pgsql-general(at)postgresql(dot)org
Envoyé le : Mardi, 16 Octobre 2007, 13h53mn 00s
Objet : Re: [GENERAL] pg_dump - schema diff compatibility

SchemaCrawler for PostgreSQL will allow you to do the diffs. With
SchemaCrawler for PostgreSQL, you can take human-readable snapshots
of the schema and data, for later comparison. SchemaCrawler outputs
details of your schema (tables, views, procedures, and more) in a diff-
able plain-text format (text, CSV, or XHTML). You can order data
alphabetically, or by ordinal order. SchemaCrawler can also output
data (including CLOBs and BLOBs) in the same plain-text formats.

SchemaCrawler for PostgreSQL is free and open-source (under the GPL),
and is available at SourceForge: http://schemacrawler.sourceforge.net/

Sualeh Fatehi.

---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

______________________________________________________________________________
Stockage illimité de vos mails avec Yahoo! Mail. Changez aujourd'hui de mail !