That really does not work. It will tell you line by line differences,
but not what object it is. Also, it does not help to generate the sql
to sync the db's.
Chris
Rosser Schwarz wrote:
>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.
>
>/rls
>
>
>