Re: [ADMIN] pg_dump formatting

2009-03-22 Thread Peter Eisentraut
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 hrhf9e83uifnskjj3h9r83hhjnnn2iyfhkjsndfi7y938hnksu879hf089h3n299ssdjfh92 3 the above

Re: [ADMIN] pg_dump formatting

2009-03-22 Thread Tom Lane
Peter Eisentraut pete...@gmx.net 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

Re: [ADMIN] pg_dump formatting

2009-03-22 Thread Tom Lane
I wrote: Peter Eisentraut pete...@gmx.net writes: 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

Re: [ADMIN] pg_dump formatting

2009-03-21 Thread Caleb Cushing
On Sat, Mar 21, 2009 at 12:58 AM, Tom Lane t...@sss.pgh.pa.us wrote: What exactly do you find un-diffable about it? after doing a bit of testing to be more explicit... pg isn't half as bad as mysql, so I've mostly been asking about something that doesn't apply... however, it seems that it

Re: [ADMIN] pg_dump formatting

2009-03-20 Thread Bruce Momjian
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

Re: [ADMIN] pg_dump formatting

2009-03-20 Thread Caleb Cushing
On Fri, Mar 20, 2009 at 10:31 AM, Bruce Momjian br...@momjian.us wrote: No, but there are database comparison tools to do that, pgdiff being one of them: after reading a bit on it (docs seem a bit light but I also looked at the mysql one), I don't think it solves my problem at all. it solves a

Re: [ADMIN] pg_dump formatting

2009-03-20 Thread Tom Lane
Caleb Cushing xenoterrac...@gmail.com writes: it'd be great if pg could have the option to dump in a more 'diff-able' way. What exactly do you find un-diffable about it? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

[ADMIN] pg_dump formatting

2009-03-19 Thread Caleb Cushing
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? -- Caleb Cushing http://xenoterracide.blogspot.com -- Sent via pgsql-admin mailing list