Is there a script to create a SQL migration file (postgres)?

Question

In the project that I work with, I sometimes have to deal with changes in the structure of the table, for example, with the addition of fields. Is there a script that can be used to generate an SQL migration file with only changes?

PHP, bash or Perl will be nice. The database is postgresql.

Answer 1

Considering CPAN , this module apparently corresponds to the account: DBIx :: Migration :: Directories .

Answer 2

- PostgreSQL Diff Tool ( java, ), , .

Answer 3

Now a similar question with answers in the DBA exists: https://dba.stackexchange.com/questions/73846/postgresql-schema-diff-patch-tool

In particular, he proposed the following options:

• Flyway migration tool where comparison with other tools is presented
• tool differences in DataGrip IDE
• liquibase comparison tool