Re: Using GIT to caught delta between database versions - Mailing list pgsql-general

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