Re: documenting tables version control

Поиск
Список
Период
Сортировка
От Tim Clarke
Тема Re: documenting tables version control
Дата
Msg-id 5549D524.3010707@manifest.co.uk
обсуждение исходный текст
Ответ на documenting tables version control  (Suresh Raja <suresh.rajaabc@gmail.com>)
Ответы Re: documenting tables version control
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Unexpected function behaviour with NULL and/or default NULL parameters
Следующее
От: Tim Clarke
Дата:
Сообщение: Re: PGFoundry Sample databases (particularly world)?