Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 26A206322F0 for ; Sun, 22 Mar 2009 07:40:54 -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 35969-04 for ; Sun, 22 Mar 2009 07:40:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gattler.pezone.net (eisentraut.org [85.214.91.16]) by mail.postgresql.org (Postfix) with ESMTP id 0DF80634FD5 for ; Sun, 22 Mar 2009 05:10:51 -0300 (ADT) Received: from vanquo.pezone.net (a91-154-107-53.elisa-laajakaista.fi [91.154.107.53]) by gattler.pezone.net (Postfix) with ESMTP id 988C315F087E; Sun, 22 Mar 2009 08:10:46 +0000 (UTC) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: pg_dump formatting Date: Sun, 22 Mar 2009 10:10:43 +0200 User-Agent: KMail/1.11.1 (Linux/2.6.26-1-686; KDE/4.2.1; i686; ; ) Cc: Caleb Cushing , Tom Lane , Bruce Momjian References: <81bfc67a0903192135v1caa41abtd4618f3df0642834@mail.gmail.com> <15202.1237611487@sss.pgh.pa.us> <81bfc67a0903212126g7377d7e4i55736a663bccf0dc@mail.gmail.com> In-Reply-To: <81bfc67a0903212126g7377d7e4i55736a663bccf0dc@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200903221010.44907.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.079 tagged_above=0 required=5 tests=AWL=0.079 X-Spam-Level: X-Archive-Number: 200903/213 X-Sequence-Number: 31713 On Sunday 22 March 2009 06:26:02 Caleb Cushing wrote: > COPY blarg (blah, bleh, blerg) FROM stdin; > 1 random character data > djfa;djjf;sdjl;afkjeoiuoiejk,cxjueiojiojeef98hkjdyf98y92hvniay8syfkdnf38932 >hrhf9e83uifnskjjjjjj3h9r83hhjnnn2iyfhkjsndfi7y938hnksu879hf089h3n299ssdjfh92 >3 > > the above in pg_dump is one line > > it'd be easier to diff if it were say on 3, or best yet with the > exception of say, binary data or things that can't be wrapped, have > the data (for like text records) wrapped at 79 characters or maybe 78 > with \ at the end or something... Maybe wdiff will do what you want.