Re: documenting tables version control

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: documenting tables version control
Date: 2015-05-06 10:04:13
Message-ID: 5549E71D.5010906@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

See comments at bottom,

On 06/05/15 20:47, Tim Clarke wrote:
> We keep the DDL statements for any tables in our subversion code
> repository just like any other programming code. Takes only a moment
> then all history or changes is available and comparable. svnserve on
> our linux server, svn workbench on my ubuntu laptop, all open source :)
>
> Tim Clarke
> On 05/05/15 21:13, Suresh Raja wrote:
>>
>> Hi All:
>>
>>
>> I have tables with different versions in the same schema. Like
>> T1a, T1b, T1c
>> T2a, T2b, T2c, T2d
>> ....
>> ...
>> etc.
>>
>>
>> I'm interested in documenting various version of tables, may be in
>> excel sheet or may be in another schema in the database. I would
>> like to store information on table name, column names, column order,
>> pry key column etc. Also is there a way I can reverse engineer from
>> the database itself.
>>
>> Let me know if anybody any suggestion or format that they used. I
>> appreciate all your help and shall be suitably acknowledged.
>>
>> Thanks,
>> -Suresh Raja
>>
>
Please don't top post in these lists.

Not upgraded to git yet??? :-)

Cheers,
Gavin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Clarke 2015-05-06 10:06:32 Re: documenting tables version control
Previous Message Tim Clarke 2015-05-06 09:12:21 Re: PGFoundry Sample databases (particularly world)?

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Clarke 2015-05-06 10:06:32 Re: documenting tables version control
Previous Message Tim Clarke 2015-05-06 08:47:32 Re: documenting tables version control