Re: Does postgresql have a diff tool?

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Graham Leggett <minfrin(at)sharp(dot)fm>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Does postgresql have a diff tool?
Date: 2026-09-14 12:37:57
Message-ID: 09FBA303-3222-4BC6-8D6A-D3FADB888C86@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> On 14 Sep 2026, at 14:33, Graham Leggett <minfrin(at)sharp(dot)fm> wrote:

> I have a piece of code that modifies a postgresql database, and I need to know precisely what changes this piece of code has made to the database. The code contains an ORM tool so it is a mystery what the tool is doing.
>
> Does there exist an equivalent of pg_dump that is capable of dumping a database in a deterministic order so that a standard diff will make sense?

This is a question better suited for the pgsql-general@ mailinglist. There are
a number of schema diff tools available, but I cannot comment on the merits of
them as I've never tried them myself.

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Reyes Bravo 2026-09-14 12:56:16 Re: Does postgresql have a diff tool?
Previous Message Graham Leggett 2026-09-14 12:33:44 Does postgresql have a diff tool?

Browse pgsql-hackers by date

  From Date Subject
Next Message Manuel Reyes Bravo 2026-09-14 12:56:16 Re: Does postgresql have a diff tool?
Previous Message Matthias van de Meent 2026-09-14 12:36:20 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)