Re: thinking about versioning my database schema

From: "Matteo Beccati" <m(dot)beccati(at)crpsoftware(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: thinking about versioning my database schema
Date: 2002-03-05 08:13:16
Message-ID: 2780D698C269CB4EB303715BA48B6A10336F@sole.CRP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Ordobas Bortolas 2002-03-05 11:44:58 simple problem
Previous Message Andrew G. Hammond 2002-03-05 06:51:38 Re: Changing sequence cache