Re : pg_dump - schema diff compatibility - Mailing list pgsql-general

From Laurent ROCHE
Subject Re : pg_dump - schema diff compatibility
Date
Msg-id 17505.38824.qm@web34414.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
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@u
The Computing Froggy


----- Message d'origine ----
De : Sualeh Fatehi <sualeh.fatehi@gmail.com>
À : pgsql-general@postgresql.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 !

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Am I overseen ?
Next
From: "Gavin M. Roy"
Date:
Subject: Re: Problem of installation on Mac