Postgres Pro
Downloads
Home   >   mailing lists

Thread: Differences between database objects (tables, triggers, sequences, functiions) and a sql file

Differences between database objects (tables, triggers, sequences, functiions) and a sql file

From
Ravi Malghan
Date:
I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences?

Re: Differences between database objects (tables, triggers, sequences, functiions) and a sql file

From
"David G. Johnston"
Date:
On Sun, Oct 29, 2023, 13:59 Ravi Malghan <ravimalghan@yahoo.com> wrote:
I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences?

Not that I know of.  You can find stuff that, once you've executed the script you can compare that database to some other and find differences.

David J.