Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YpuzT-0005Vk-VQ for pgsql-general@arkaria.postgresql.org; Wed, 06 May 2015 08:47:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YpuzS-0000xg-Qe for pgsql-general@arkaria.postgresql.org; Wed, 06 May 2015 08:47:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YpuzQ-0000xX-Ij for pgsql-general@postgresql.org; Wed, 06 May 2015 08:47:36 +0000 Received: from [77.44.84.211] (helo=man7.m1.manifest.co.uk) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YpuzN-0005VF-Sg for pgsql-general@postgresql.org; Wed, 06 May 2015 08:47:35 +0000 Received: from [200.200.200.20] ([200.200.200.20]) by man7.m1.manifest.co.uk with Microsoft SMTPSVC(6.0.3790.4675); Wed, 6 May 2015 09:47:32 +0100 Message-ID: <5549D524.3010707@manifest.co.uk> Date: Wed, 06 May 2015 09:47:32 +0100 From: Tim Clarke User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: documenting tables version control References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------080207070401040207030709" X-OriginalArrivalTime: 06 May 2015 08:47:32.0740 (UTC) FILETIME=[4ADD1440:01D087D9] X-Host-Lookup-Failed: Reverse DNS lookup failed for 77.44.84.211 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------080207070401040207030709 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 > --------------080207070401040207030709 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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

--------------080207070401040207030709--