PGDiff dumps

[cesar-lizurey]

Hello,
First of all thanks for your work which helps a lot. I'm using pgdiff in my pipeline to generate migration files.
Connecting to databases is slow and risky, I'd like to use it to check the diff between two dump files bdd_prev.sql and bdd_next.sql.
Is there any way I could make it possible without having to create 2 databases on the fly in my pipeline?
Thanks a lot!

[joncrlsn]

Hi Cesar, this tool requires a working database. Could you format the SQL in such a way that you can use the standard Linux diff tool?

…

On Thu, Feb 6, 2025, 08:11 César Lizurey ***@***.***> wrote: Hello, First of all thanks for your work which helps a lot. I'm using pgdiff in my pipeline to generate migration files. Connecting to databases is slow and risky, I'd like to use it to check the diff between two dump files bdd_prev.sql and bdd_next.sql. Is there any way I could make it possible without having to create 2 databases on the fly in my pipeline? Thanks a lot! — Reply to this email directly, view it on GitHub <#56>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAA7KRCUBGWKCI2QDDJ35JL2ONUSDAVCNFSM6AAAAABWTUTQPSVHI2DSMVQWIX3LMV43ASLTON2WKOZSHAZTKNRUHE2DAMQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[cesar-lizurey]

Hi Jon,
Unfortunately the standard Linux diff tool only gives me the text difference, that means it I add a column in a table, I won't have a "ALTER TABLE" command.