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 (pgs
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
On Fri, Mar 20, 2009 at 10:31 AM, Bruce Momjian 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
similar one.
Caleb Cushing 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 to your subscription:
On Sat, Mar 21, 2009 at 12:58 AM, Tom Lane 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 creates 1 line per row,
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 a
Peter Eisentraut 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
>> hrhf9e83uifnskjj3h9r83hhjnnn2iyfhkjsndfi7y938hnksu87
I wrote:
> Peter Eisentraut 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
> between fie