Re: [SQL] documenting tables version control

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] documenting tables version control
Date: 2015-05-06 14:40:48
Message-ID: 554A27F0.7010602@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On 05/06/2015 07:31 AM, Suresh Raja wrote:
> Thanks Melvin, Joshua, PT and Steve!
>
> your information is good. Im looking for creating a catalog for my
> application schema. Do you have anything that you use for catalog of
> your schema. Maybe using excel.

Yes Mercurial(mercurial.selenic.com) with Sqitch(sqitch.org). Then you
get a current catalog and a history of your catalog changes in Mercurial
and a way to go backwards and forwards in deploying those changes using
Sqitch.
>
> Thanks,
> SR

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sujit K M 2015-05-06 14:59:06 Fwd: [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA
Previous Message Steve Midgley 2015-05-06 14:36:54 Re: [GENERAL] documenting tables version control

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Dudgeon 2015-05-07 10:56:42 generating json without nulls
Previous Message Steve Midgley 2015-05-06 14:36:54 Re: [GENERAL] documenting tables version control