Does postgresql have a diff tool?
Hi all,
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?
Regards,
Graham
--
On 14 Sep 2026, at 14:33, Graham Leggett <minfrin@sharp.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