diff speaks the wrong language to accomplish that, other elementry parts.
There exists a program named pgdiff on gborg.
On the other hand there's EMS database comparer http://www.sqlmanager.net/
|-----Original Message-----
|From: Milorad Poluga [mailto:[EMAIL PROTECTED]
|Sent: Donnerstag, 23. Juni 2005 16:11
|To: [email protected]
|Subject: [ADMIN] How to compare the schemas ?
|
|
|Hi everyone,
|
|I am looking for the best way to compare the schemas of two
|databases with the very similar structure.
|One (certainly not the best options) is to do something like this:
|
|pg_dump ... DB1 > PG_SCHEMA1
|pg_dump ... DB2 > PG_SCHEMA2
|diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
|
|kwrite differences.txt
|
|Any suggestions or ideas on how to overcome this are welcome.
|
|Thanks in advance,
|
|Milorad Poluga
|HK CORES Beograd, Makenzijeva 31
|[EMAIL PROTECTED]
|
|--
|---------------------------------------
|Milorad Poluga
|HK CORES Beograd, Makenzijeva 31
|[EMAIL PROTECTED]
|+381-11-30-80-461
|---------------------------------------
|
|
|---------------------------(end of
|broadcast)---------------------------
|TIP 4: Don't 'kill -9' the postmaster
|
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
