roggy
- Message d'origine
De : Sualeh Fatehi <[EMAIL PROTECTED]>
À : 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 Pos
2007/10/16, Sualeh Fatehi <[EMAIL PROTECTED]>:
> 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, pr
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 (
Just an idea, but I would try to:
- pg_dump both schemas in 'custom' format
- extract TOC from each one
- use the lists as a basis for compare
(i guess that's what pgdiff does, maybe it just needs minor patch to
extend its functionality )
2007/10/12, Tomi N/A <[EMAIL PROTECTED]>:
> Looking at
rk on it
(diff, automatic modifications, ...).
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Tomi N/A <[EMAIL PROTECTED]>
À : postgres general
Envoyé le : Vendredi, 12 Octobre 2007, 15h46mn 29s
Objet : [GENERAL] pg_dump - schema diff compatibility
Looking at the mailing list archive, this is just one in a rather long
line of questions regarding diffing db schema dumps, but I've been
unable to find what I was looking for in any of the prior
conversations. I know of apgdiff (seems to work very nicely) and of
other specialized pg diff tools (as
