Upgrading an existing database structure

From: Chitra Creta <achitraleka(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading an existing database structure
Date: 2011-10-24 06:26:01
Message-ID: CAG6nG0nAibvRZN+VLXZsyEW4qmhHsDFnaMVVzpbFA2Xq9H9y9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I am interested in knowing how to upgrade a database structure on an
existing database.

I have a script that creates and alters tables, columns and data. When this
script is run, errors are thrown for already inserted tables, columns and
data. Anything that is not found in the existing database is then executed.
This prevents existing data to not be wiped out. Does anyone else have a
better way of upgrading a database structure on an existing database?

Thanking you in advance.

Browse pgsql-general by date

  From Date Subject
Next Message Javier Amor garcia 2011-10-24 07:27:36 Error inserting RFC1738-encoded URLs
Previous Message Prakash, Deepthi (NSN - IN/Bangalore) 2011-10-24 06:08:07 Re: Autentication exceptions in pgsql 8.3