Thank you geoff! I think that i will test http://www.liquibase.org/ this one.
what about setting up trigger to metadata (structural table) to find if column was added for example? Best, Jacek 2018-02-26 16:43 GMT+01:00 geoff hoffman <ge...@rxmg.com>: > > > There’s https://flywaydb.org/ > and http://www.liquibase.org/ > > More: https://dbmstools.com/version-control-tools > > Also, if you know PHP, Laravel database migrations have worked great for > us! > https://laravel.com/docs/5.6/migrations > > > > On Feb 26, 2018, at 3:44 AM, Łukasz Jarych <jarys...@gmail.com> wrote: > > i would like to ask you for help with track changes to my database. > I am new to PosgtreeSQL but i have to learn it quickly because of my boss. > > I have to: > > 1. Keep all changes within table including: > -adding rows > -deleting > -editing > > 2. Save table with specific state and recover specific state (so go back > to previous table versions) including comparing tables. > > 3. Track all DLL and DML changes with possibility to ho back to previous > version. > > >
