From: James Olin Oden <joden@lee.k12.nc.us>
To: Cary B. O'Brien <cobrien@access.digex.net>
Cc: fmorton@mail.base2inc.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] add/delete field utility?
Date: Fri, 4 Sep 1998 07:40:28 -0400
Message-ID: <81Sep3.063049edt.35713@gateway.lee.k12.nc.us> (raw)
References: <199809031744.NAA07093@access1.digex.net>
> > 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.
>
Also, he should be able to come with some script or program in any one of the
numerous languages out there to automate the processes so that he can perfect the
process once on his test database, and then just run one command on each of the
other workstations.
...james
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: joden@lee.k12.nc.us, cobrien@access.digex.net, fmorton@mail.base2inc.com
Subject: Re: [INTERFACES] add/delete field utility?
In-Reply-To: <81Sep3.063049edt.35713@gateway.lee.k12.nc.us>
* 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