Re: Using GIT to caught delta between database versions

Hi Adrian,

thank you .

why i should use sqitch or any other software to catch the delta?

When i will export plan-text SQL , git should catch delta automatically?
Can you please explain it?

Best,
Jacek

2018-06-13 19:47 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> 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(dot)klaver(at)aklaver(dot)com
>