Re: How to store version number of database layout

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