X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69C72529DB for ; Tue, 28 Jun 2005 06:20:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75768-05 for ; Tue, 28 Jun 2005 09:20:06 +0000 (GMT) Received: from mail.gmx.net (imap.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 5422A52993 for ; Tue, 28 Jun 2005 06:20:04 -0300 (ADT) Received: (qmail invoked by alias); 28 Jun 2005 09:20:06 -0000 Received: from dsl-082-083-232-093.arcor-ip.net (EHLO colt.pezone.net) [82.83.232.93] by mail.gmx.net (mp017) with SMTP; 28 Jun 2005 11:20:06 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: Milorad Poluga Subject: Re: How to compare the schemas ? Date: Tue, 28 Jun 2005 11:20:04 +0200 User-Agent: KMail/1.8.1 Cc: pgsql-admin@postgresql.org References: <200506231611.08521.milorad.poluga@cores.co.yu> In-Reply-To: <200506231611.08521.milorad.poluga@cores.co.yu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200506281120.05150.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/254 X-Sequence-Number: 18009 Milorad Poluga wrote: > 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 What is wrong with that? -- Peter Eisentraut http://developer.postgresql.org/~petere/