Updating database structure

From: Luuk Jansen <subscribe(at)angelosystems(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Updating database structure
Date: 2006-03-22 19:40:01
Message-ID: 1143056401.3549.8.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a problem with finding a way to update a database structure.
This might be a very simple problem, just cannot find the info.

I am looking at updating the structure of my database. I put an
application on my production server some time ago and further developed
the application till a point I have to merge the changes.

How can I update the structure on the production server to reflect the
database on my test machine in an easy way with preservation of the data
on the production server. There are no major changes in the fields types
etc., mainly additions/deletions of fields in the tables.

Thanks,

Luuk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-03-22 19:48:39 Re: question about the admin contrib module and binary
Previous Message postgresql 2006-03-22 19:36:37 how to update structural & data changes between PostgreSQL databases?