Re: How to store version number of database layout

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to store version number of database layout
Date: 2013-02-12 10:40:00
Message-ID: 511A1C00.9000801@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2013-02-12 10:56:29 Re: How to store version number of database layout
Previous Message Seref Arikan 2013-02-12 10:39:16 What does Postgresql do when using CASE WHEN without ELSE?