Re: How to store version number of database layout - Mailing list pgsql-general

From John R Pierce
Subject Re: How to store version number of database layout
Date
Msg-id 511A1C00.9000801@hogranch.com
Whole thread Raw
In response to How to store version number of database layout  (Frank Lanitz <frank@frank.uvena.de>)
Responses Re: How to store version number of database layout  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
On 2/12/2013 2:01 AM, Frank Lanitz wrote:
> t's more like a question of best practice:
> How do you managing different version of database layout for e.g.
> software releases?
> We are planing to do an application based on postgres and want to store
> some version number of database layout to ensure correct upgrade-scripts
> can be applied in case of an upgrade. Is there any build in for?
my projects, we have a small table "settings",  with  key text, value
text.  one row is 'SCHEMA_VERSION','1.0.5'



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Seref Arikan
Date:
Subject: What does Postgresql do when using CASE WHEN without ELSE?
Next
From: Chris Travers
Date:
Subject: Re: How to store version number of database layout