Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Schema comparisons

From: "Bort, Paul" <pbort(at)tmwsystems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [ADMIN] Schema comparisons
Date: 2004-02-29 01:27:10
Message-ID: 735D404BD9E7EB44B9CDFC27FC88809B01C4D52E@mail2.tmwsystems.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Ordering the pg_dump output by name within classes instead of OID sounds
good to me, too. 

Also, something that might be easier for comparing schemata between
databases: rather than dumping the database, have you tried using PostgreSQL
Autodoc (http://www.rbt.ca/autodoc/) which just outputs the schema in a
variety of formats (including XML for dia and DocBook). It just seems that
if you're only concerned with structure, and not content of user tables,
this could at least shorten the amount of data to be compared, if not get
you into a space where there's already a tool to do all the work (I don't
know if there's an XML-smart diff.)


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-02-29 01:27:45
Subject: Re: log_line_info
Previous:From: Bort, PaulDate: 2004-02-29 01:18:45
Subject: Re: Collaboration Tool Proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group