Postgres Pro
Downloads
Home   >   mailing lists

Re: Database version control - Mailing list pgsql-novice

From Emil Oppeln-Bronikowski
Subject Re: Database version control
Date
Msg-id 1195542507.29308.9.camel@heroina
Whole thread Raw
In response to Database version control  (Alex du Plessis <alexdup01@telkomsa.net>)
Responses Using Execute with Dynamic Raise Commands
List pgsql-novice
Tree view 
Dnia 19-11-2007, Pn o godzinie 22:46 +0200, Alex du Plessis pisze:

> Is there any way to do version control on a database from one
> application version to another?

    I just have database structure near code and I manage it with
Subversion. But my favorite way to keep changes visible is to have basic
structure and keep all ALTER queries in files. Then I have
00BasicStruct.sql 01PasswordField-20071212.sql and so on, After I'm
close to freeze, I build clean structure and dump it into Subversion
repo

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Database version control
Next
From: "Mag Gam"
Date:
Subject: need trigger help