From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Comparing database schema's |
Date: | 2004-08-03 11:47:08 |
Message-ID: | cenu0p$bh0$1@floppy.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tom Lane wrote:
> Frank Kurzawa <fkurzawa(at)topazsoftware(dot)com> writes:
>
>>How are people doing automated comparisons of schemas in different databases?
>
>
>>I've experimented some with 'pg_dump -s' to do this: Do a schema dump
>>on the two databases and a diff. But due to myriad small differences
>>(order of creation of tables, constraints, etc.) it is very difficult
>>to get a usable diff without engaging in massive massage of the dump
>>output, including dumping a table at a time.
>
>
> FWIW, some attention has been paid to this issue recently. I think CVS
> tip pg_dump is more useful for this task than existing releases. Don't
> suppose you'd want to try it out?
Yes, indeed now pg_dump when possible dump the objects in alfabetic order
so shall be easy to perform a diff between the two schemas.
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | mike | 2004-08-03 12:15:02 | help with COPY from .csv file into database |
Previous Message | Steve Tucknott | 2004-08-03 06:43:58 | Re: Significant trailing spaces |