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.klaver@xxxxxxxxxxx>:
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@xxxxxxxxxxx