while you weren't looking, Chris Hoover wrote:
> Does anyone know of any good tools that will compare 2 db's and generate a complete listing of any object differences?
Perhaps something like:
$ pg_dump --schema-only db1 > db1.sql
$ pg_dump --schema-only db2 > db2.sql
$ diff db1.sql db2.sql
would accomplish what you're after? It does specifically list GRANTs,
among other things.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-12-20 19:01:09|
|Subject: Re: From latin9 to sql_ascii?? |
|Previous:||From: Helena Lourenco||Date: 2004-12-20 17:23:02|
|Subject: unsubscribe pgsql-bugs|