From: "Cary B. O'Brien" <cobrien@access.digex.net>
Message-Id: <199809031744.NAA07093@access1.digex.net>
Subject: Re: [INTERFACES] add/delete field utility?
To: fmorton@mail.base2inc.com
Date: Thu, 3 Sep 1998 13:44:19 -0400 (EDT)
Cc: pgsql-interfaces@postgreSQL.org
In-Reply-To: <002201bdd751$c8158be0$8355e5ce@tesla.base2inc.com> from Frank
	Morton at "Sep 3, 98 10:44:48 am"
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> Is there a utility anywhere that can take an existing
> database and add or delete fields/tables? I often
> need to update databases on multiple machines
> that need the same structure but have different data,
> so dumping the data base, updating in a text editor
> and reloading gets too tedious and the sizes of
> all these are going to get too large eventually.
> 

I'm not sure I understand the question, but can't you do this with
psql?  You can add and delete tables, and add fields easily (alter table ...).

Dropping a field (column, attribute, whatever) can be done by creating
a temporary table via a select with the columns you want, dropping the
old table, and renaming the temp table to what you want.

Am I misunderstanding the question?

-- cary