Re: Updating database structure

From: Johan Vromans <jvromans(at)squirrel(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Updating database structure
Date: 2006-03-22 20:07:57
Message-ID: m2k6amnsyq.fsf@phoenix.squirrel.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Luuk Jansen <subscribe(at)angelosystems(dot)com> writes:

> 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.

ALTER TABLE ?

-- Johan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2006-03-22 20:21:50 Re: how to update structural & data changes between PostgreSQL
Previous Message Tom Lane 2006-03-22 20:06:18 Re: PANIC: heap_update_redo: no block