Re: thinking about versioning my database schema - Mailing list pgsql-sql

From Matteo Beccati
Subject Re: thinking about versioning my database schema
Date
Msg-id 2780D698C269CB4EB303715BA48B6A10336F@sole.CRP
Whole thread Raw
In response to thinking about versioning my database schema  (Janning Vygen <vygen@gmx.de>)
List 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 by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: Changing sequence cache
Next
From: Ismail Bouabdallah
Date:
Subject: ERROR: fmgr_info: function 56664: cache lookup failed