Re: thinking about versioning my database schema

Поиск
Список
Период
Сортировка
От Matteo Beccati
Тема Re: thinking about versioning my database schema
Дата
Msg-id 2780D698C269CB4EB303715BA48B6A10336F@sole.CRP
обсуждение исходный текст
Ответ на thinking about versioning my database schema  (Janning Vygen <vygen@gmx.de>)
Список pgsql-sql
Hi,

> How about a script that dumps your data, dumps your db, 
> reloads the table
> definitions, then reloads your data? You could have a table 
> with rows for
> every table that would keep track of the current version you 
> have, that
> could be updated when this script ran.

This is exactly what I did for the update script of my own project
phpPgAds...

You could take a look to the code if you're interested

http://phppgads.sourceforge.net

Regards
--
Matteo Beccati



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Andrew G. Hammond"
Дата:
Сообщение: Re: Changing sequence cache
Следующее
От: Ismail Bouabdallah
Дата:
Сообщение: ERROR: fmgr_info: function 56664: cache lookup failed