Jan 21

PostgreSQL Diff Tool

A simple command line tool written in Python to display basic table differences between two PostgreSQL databases. This tool is different from pgdiff, in that it is not web based and can be run from the command line. It can be useful for comparing and tracking down differences between production and development databases.

Download
pg_diff

Date January 21st, 2008 Filed in Other

5 Responses to “PostgreSQL Diff Tool”

  1. bob Says:
    February 10th, 2008 at 9:27 am

    eNkAZE hi great site thx http://peace.com

  2. Celebrity Says:
    June 12th, 2008 at 11:31 pm

    very cool.

  3. SMS Alerts Says:
    October 4th, 2008 at 6:58 pm

    Very nice! Thanks for the share, i’ll be sure to put the information into use. Keep the good blog posts coming!

  4. Digital books Says:
    November 11th, 2008 at 5:55 pm

    I was searching for command tool like this ..!!
    Thanx

  5. Pierre Chevalier Says:
    December 14th, 2008 at 5:32 pm

    Hello,

    Nice utility. But I’m looking for something else:
    “It does NOT compare the data in the tables.”

    Well, this is what I’m looking for.
    For the moment, I use psql ascii output and diff, but the tables I’m dealing with are *very* wide, which makes the output quite unreadable. Only gvimdiff or tkdiff can display something interesting, but still, this is far to be ideal.

    Do you know of any tool/script that would perform a diff on two tables contents, highlighting the different records / fields?

    Regards.
    A+
    Pierre

Leave a Reply