Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 849A06327F2 for ; Fri, 20 Mar 2009 11:31:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 87961-01 for ; Fri, 20 Mar 2009 11:31:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 328D96327AA for ; Fri, 20 Mar 2009 11:31:37 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id n2KEVZj04033; Fri, 20 Mar 2009 10:31:35 -0400 (EDT) From: Bruce Momjian Message-Id: <200903201431.n2KEVZj04033@momjian.us> Subject: Re: pg_dump formatting In-Reply-To: <81bfc67a0903192135v1caa41abtd4618f3df0642834@mail.gmail.com> To: Caleb Cushing Date: Fri, 20 Mar 2009 10:31:35 -0400 (EDT) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/203 X-Sequence-Number: 31703 Caleb Cushing wrote: > is there any way to format the output of pg_dump? in a way that is > more diff-able? like line wrap on each row, record or something? that > way you can easily find the differences of each dump if need be? No, but there are database comparison tools to do that, pgdiff being one of them: http://pgdiff.sourceforge.net/ -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +