From: Cary B. O'Brien <cobrien@access.digex.net>
To: fmorton@mail.base2inc.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] add/delete field utility?
Date: Thu, 3 Sep 1998 13:44:19 -0400 (EDT)
Message-ID: <199809031744.NAA07093@access1.digex.net> (raw)
In-Reply-To: <002201bdd751$c8158be0$8355e5ce@tesla.base2inc.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: cobrien@access.digex.net, fmorton@mail.base2inc.com
Subject: Re: [INTERFACES] add/delete field utility?
In-Reply-To: <199809031744.NAA07093@access1.digex.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox