Search Postgresql Archives

Re: Using GIT to caught delta between database versions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux