Re: Using GIT to caught delta between database versions

On 06/13/2018 10:42 AM, Łukasz Jarych wrote:

Hi Guys,

how use git to catch delta between database versions?

Use sqitch?:

https://sqitch.org/

As version i will do schemas.
So we have version one, finishing it, and this version should be put in GIT.
And created schema for the version.

Which formats i should use?

pg_dump creates only binary files? (i should use text file here).

It will create text files, that is actually the default:

https://www.postgresql.org/docs/10/static/app-pgdump.html


-F format
--format=format

    Selects the format of the output. format can be one of the following:

    p
    plain

        Output a plain-text SQL script file (the default).

Best,
Jacek

--
Adrian Klaver
adrian.klaver@aklaver.com