Peter Eisentraut <peter_e@xxxxxxx> writes: > 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. I don't think we'd consider making the kind of changes to the COPY specification that would be needed to allow this sort of thing in COPY mode. However, it'd be pretty trivial to put \n instead of space between fields in the INSERT dump formats. I wonder whether that would answer the need ... regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin