Postgres Pro
Downloads
Home   >   mailing lists

Re: documenting tables version control - Mailing list pgsql-general

From Tim Clarke
Subject Re: documenting tables version control
Date
Msg-id 5549D524.3010707@manifest.co.uk
Whole thread Raw
In response to documenting tables version control  (Suresh Raja <suresh.rajaabc@gmail.com>)
Responses Re: documenting tables version control  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Unexpected function behaviour with NULL and/or default NULL parameters
Next
From: Tim Clarke
Date:
Subject: Re: PGFoundry Sample databases (particularly world)?